Math Problem w/ Reports - Need Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have information that I would like to print out in my report, much like
when it sums the information for you. However, what I need the report to do
is subtract the information in the columns not add it. Is there a way to do
this in the reports section? If not how could I build a query to do this?
Example of what I am looking for is below.

Week# Day Date Sales Total NOR
32 Tues 20040809 879005 5.476988186
20050808 924072 4.945177432

'Day' = Tues (2 detail records)
45067 0.5318100754

Can anyone help?
 
You've provided a sample of the output -- how you want your results
displayed.

What we don't know is your input -- how your data is stored.

A query may (or maybe not?!) be able to take your (table) data and massage
it part-way (or all the way) into what you want printed in your report.

Specifically how it would do that will depend on how your data is stored!
 
Back
Top