Query help.......

  • Thread starter Thread starter Jaffa
  • Start date Start date
J

Jaffa

Hi everyone....

I'm having trouble doing a query. I have a database compiled of about 6
tables which include customer details, employee details, order details etc.

What I need to do is produce an invoice for each customer that has not yet
recieved an invoice calculating the sale of the goods bought.

Now I think I know how to write the criteria but what I don't understand or
can't do is add an extra field/column for "sales total".

If anyone understands what I mean and thinks they can help, please, please,
please respond....

Thanks for your time.....

P.s. I'm using Access 2002.......
 
Assuming that you will be printing one invoice per customer, and that the
report will be filtered to each customer one at a time, don't put such a
calculated field in your query. Instead, put a textbox on the report in the
report footer, and set its control source to an expression that sums the
goods' sale prices. Something like this:
=Sum([GoodsSalePriceField])

Note that you must use the * field name * that contains the prices of the
goods -- do not use the textbox name on the report that is displaying the
actual price of the goods.
 
Back
Top