Help with invoice problem

[rvd48]

i have to set up a invoice. my database is about selling books,
if a customer wants 20 copies of a book, then i enter the book id into the table, but how do i get the books unit price to appear at the same time as well ?

 

[statsman]

I assume you have the unit price somewhere in your database (otherwise, how do you know how much 20 copies cost).
Are you using a REPORT for your invoice? If so, simply add a text box with the unit price into your report.
If you are printing your invoice using word or some other program, you will have to add the unit price from your query into the invoice.

 

[rvd48]

thanks, got it sorted before u replied. yes, i have the cost of the book in the stock table.

my next problem i have hit is: VAT calculations

each book has a Catagory ID: Humour, Fiction and History.
Humour books have a VAT rating of 17.5% and history + fiction are rated at 0%.
im not sure how to add 17.5% on a fiction book, without messing the whole database , up any help?

EDIT: i have uploaded my database. the book details along with the catagory id is in the table called "stock"

 

[Meltdown]

sorted your VAT and Totals...see attachment

 

[rvd48]

sorted your VAT and Totals...see attachment

im a bit confused at how u got the different VAT ratings

 

[Meltdown]

I added a new VAT table, open it up and delete whatever you don't want.

 

[rvd48]

i kinda solved the problem in my original table, but now in Query, in my "order" query, it wont give the autonumber so i cant add a new field, can you help.

i've uploaded it

EDIT, wtf, i've deleted some reports, yet it still says 1.03MB !

u got msn messenger mate?

 

[Meltdown]

No I don't, go to Tools > Options > General Tab...and click the option 'Compact on Close', that should solve the bloat problem, and bring the db below 100K

 

[rvd48]

thanks mate, have uploaded it now

its in the "order" query, i dont see why the auto number thing isnt there

 

[Meltdown]

Sorry, I got called away, anyway, I removed your grouping from the subform query as there can never be any duplicates in a lineitem to group.

 

[rvd48]

thanks meltdown.
it was that darn Sum button then !

my next problem is, when i create a report to make a invoice, it displays all the Order IDs, i just want it to show 1 order id and hence only the books ordered on that order id.
if you look at the report "orders 1", then you will see what i mean by all the order ID's and there following details being together

 

[Meltdown]

...Added a report button to the Order form that opens the relevant record.

 

[rvd48]

lol, never thought about that !

thanks, the report has to be a invoice to the customer, so i gotta add customer address,etc fields into it.


many many thanks melt down, i would have been here all night trying in vien !

 

[rvd48]

help

in the form "order" , its not displaying the total cost of all the books for each order id,
also, in the report "Orders 1", i cant get the sum total figure to work.

any help ?