1 Topic by asperen1959

(2 replies, posted in General)

I have a problem with some fields within my form.
Several fields I want to calculate but how must I do that?
Is it possible to do it in the form or is it better to save the calculation in the database.

For example I have a database with products and there is also a price_sale in this database.
This is the sales price for the product per piece. I have a sales database in which I put the quantity of the sold products.
Now I want to calculate the total price of it including VAT.

For example price per piece = 4086, I sell 10 pieces, the result must be (10 * 4086) + VAT 27% = 51892.
Also the VAT price must be calculated and stored into the database.

In the form the price per piece must be taken from the database and can not be filled in or changed in the form.
Only the quantity can be filled in and the rest must be calculated and/or stored.
Can you please help me. Thank you very much again.

Go to forum: General

2 Reply by asperen1959

(2 replies, posted in SQL queries)

Thanks, but first I will try this import.vdb and if I do not succeed I will send you my project and CSV file. But first I want try it myself. I need to learn.

Go to forum: SQL queries

3 Topic by asperen1959

(2 replies, posted in SQL queries)

I have a .CSV file with 3.147 records in 3 columns. Can I load this into my database made by MVD? So yes, how.

Go to forum: SQL queries

4 Reply by asperen1959

(4 replies, posted in Reports)

Thank you all. I solved the problem already on my own. Error in form and database.

Go to forum: Reports

5 Topic by asperen1959

(4 replies, posted in Reports)

Started today with My Visual Database. I must say it looks great, but my first try is not a success. When I run a form I get the error message: "Cannot make a visible window modal". What am I doing wrong?

Go to forum: Reports