Query help.......

[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.......

 

[Ken Snell]

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.