Hi I wonder if you can help me with a problem I have with my database. its nearly midlnight and I need it for tomorrow so I will be up all night.
I would really appreciate if you could help me resolve a problem I have.
I have made all of my database except for a small part which I cant crack due to lack knowledge.
The form I have has 10 different line price boxes to add up. cant get the sub total to add them all up.
The price for any item is randon so I cant use a price table. the price's are completly random entries into the price field. and the invoice form needs to add on a VAT of 15%
Problem 2
I need to look at the relationships so that when an order is input on the sales form, it saves a copy for print or storage in the invoice table.

I would be willing to pay for your services but the most I have to offer is £50
Im desperate and like I said earlier I will be awake until I can resolve these issues.

Hi I wonder if you can help me with a problem I have with my database. its nearly midlnight and I need it for tomorrow so I will be up all night.
I would really appreciate if you could help me resolve a problem I have.
I have made all of my database except for a small part which I cant crack due to lack knowledge.
The form I have has 10 different line price boxes to add up. cant get the sub total to add them all up.
The price for any item is randon so I cant use a price table. the price's are completly random entries into the price field. and the invoice form needs to add on a VAT of 15%
Problem 2
I need to look at the relationships so that when an order is input on the sales form, it saves a copy for print or storage in the invoice table.

I would be willing to pay for your services but the most I have to offer is £50
Im desperate and like I said earlier I will be awake until I can resolve these issues.

problem 1
in the footer of the report/form put a text =Sum([feildname]) or =[feildname]+[feildname]+[feildname]

vat = (([newly added text]*.15) + [newly added text]) some like this

problem 2
question what the differance between sales form and invoice table
why just add a feild to the sales form invoice (T/F) or even beater add a invoice date feild if 'invoice date' = null then not invoice
then what i do is create a payment table which only has invoiceID, amount Paid,date paid then you can write a outter join to show how has not paid there invoices.

I guess he fell asleep ^^

Is this homework??

hi sorry not asleep was racking utube and trying to build expressions to work out the prices.

so yeah im still here.
can i email this to ya my head is shot, been trying to solve this for days.

Regards
mark

I tried =[item Price 1] + [Item Price 2], all the way upto 10 works great on the first record, then stops working.

Thanks
mark