Question Invoices - adding VAT - HELP!!!

Local time
Today, 15:27
Joined
Jan 30, 2009
Messages
5
I am new to Access, never seen it before let alone used it! I am learning fast, picking up what to do but I am now stuck! on invoices, I need to add in the VAT - I have managed (more luck than judgement I think!) to get a VAT category onto the invoice form document and somehow the actual amount of VAT - but I cannot find the way of adding the amount of VAT to the total to give the amount payable - Have been at this for DAYS and can no longer see wood for trees.
Slowly going MAD - Can anyone please tell me, in words of one syllable, a simple way of what I am supposed to do for adding VAT? I am using the time and billing invoice template. Is it something to do with expressions?
Apprecaite any help.
thanks
lyn
 
OK-

Tax should be stored in a seperate table (never hard code tax in )

-

now what version of access are you using?

show us the steps you have taken
 
Tax Rates in one table

Options:

Sales Header
Tax Code

Or

Sales Detail
Tax Code

or

Both

The Tax Code on the Sales Header acts as the default Tax code for the Detail as there are instances where some goods or services are exempt from VAT.

Query on Sales Detail
Link into Tax Table

Sales Details

Selling Price
Tax Amount

Simon
 
have alook at the attached - it shows how to do this one the form

look at the after updates on the combo box and also the first figure box


this gives you some insight - and should help on reports

(Note and a big NOTE) always keep tax in a table never hard code it it -
 

Attachments

Thank you for the response. I shall try these suggestions. Appreciate your assistance - I have used various databases in my time, but there are some aspects of Access 2007 I find difficult to follow.
Thanks for the help - fingers crossed!
lyn
 

Users who are viewing this thread

Back
Top Bottom