Subtotal/Vat help

[KenshiroUK]

Hi all I currently have an Orders form for which it is supposed to breakout the Subtotal, VAT, Shipping Charge and Total.

In my VAT code I have =[txtOrderSubtotal]*1.2-[txtOrderSubtotal] This breaks the VAT out.

However in Order Total it does not seem to be adding the VAT on to the price.

This is what I have in my Subtotal

=[txtOrderSubtotal]+Nz([FreightCharge])+Nz([Taxes])

Can anybody help me out here?

 

[pr2-eugin]

Why not include that in your Source Query and assign the controls the fields rather than adding it to the Control Source?

 

[KenshiroUK]

Why not include that in your Source Query and assign the controls the fields rather than adding it to the Control Source?

I'm not really savvy with Access, how would I do that?

 

[pr2-eugin]

So what is the RecordSource of the Form?

 

[KenshiroUK]

So what is the RecordSource of the Form?

I cannot find the record source, I can find the control source. can I zip it up and post it on here?

 

[pr2-eugin]

Yes, please make sure that you include the names of Form/Query that the problem is dealing with.

 

[KenshiroUK]

Okay I have attached a copy of the DB I am working on. As you can see from first order that appears the VAT is not being added. Seem to be having some issues uploading this.

 

[bob fitz]

Okay I have attached a copy of the DB I am working on. As you can see from first order that appears the VAT is not being added.

Your attachment is not showing

 

[KenshiroUK]

Is it possible to PM me they're email so I could send it via email?

Thanks.

 

[pr2-eugin]

You can upload the DB here.. Just go to 'Go Advanced' and then Manage attachments..

 

[KenshiroUK]

Still not working correctly.

 

[pr2-eugin]

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

 

[KenshiroUK]

Hi all I'm still trying to upload it and it still seems to be going very slow, even if I have compacted it.

 

[KenshiroUK]

Sorry for late reply finally got it uploaded. As you can see from the Order form the VAT is not being added at the bottom.

 

[bob fitz]

Add the VAT calculation to the expression in the Total. See attached file.

 

[KenshiroUK]

Thank you! Is there a way to say if the actual Sub Total is UNDER £50.00 apply a £20.00 fee in the Shipping & Handling? To do with If statement, but not sure where to post it?

 

[bob fitz]

The attached db has code in the After Update event of the sub form which inserts the “Freight Charge” when appropriate. Because the criteria used may be subject change, I have added a table in which the criteria for “Freight Charge” and the amounts to be charged can be saved and a query that is used to return the appropriate “Freight Charge” depending on the “Order Date” and the “Sub Total” on the main form. As the “Freight Charge” control on the main form is bound to the “Orders” table, the “Freight Charge” is saved in that table. Although we would not normally save calculated data (usually it is calculated when and wherever it is required), IMHO it would right and proper to do so here.

I am not a accountant, but perhaps a similar arrangement should be used for the VAT rate applied to each item on the order as VAT rates also change from time to time.