query calculation

[Ali29J]

Hi All

Can anyone help me, I have a query with a caluclated total, which works fine, it sums the number to be purchased and cost to get a total value. but what i would like to do is to then add these totals to get a calculate the total per customer how would i go about doing this? i do not know where to begin....

Appreciate if anyone can point me in right direction...ultimately this value i would like to link to a xls sheet for sales figures

please help me to at least get started.

Thanks

Ali

 

[PHV]

Without your actual tables schema it's hard to say anything ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

at least post the SQL for the query you are currently using...

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual