Need help with subtraction in reports please

  • Thread starter Thread starter scott munkirs
  • Start date Start date
S

scott munkirs

Hi

I have created a query that will ask for 2 dates and it will provid
me with the net sales and invoices for both days. I got the dat
field and the net sales and invoices field from the same table

The query works fine and all until I want to do some calcualtions in
report. I set the report up to show the information on the report i
column form and on the footer section I created a SUM operator t
show the totals pf the net sales for both days but I also want t
create a total on the report that will show the DIFFERENCE betwee
the net sales for those 2 days. I cannot get it to subtract at all
It always gives me a 0.00. (It takes the last net sales (the 2n
date) and subtracts itsefl to get 0.00) I would like the Subtractio
to be like the sum and subtract both net sales and give me th
difference

The query consisted of the date field with a simple OR criteria an
the net sales and Invoice fields too

Any help would be a big help

Scott Munkir
 
scott munkirs said:
I have created a query that will ask for 2 dates and it will provide
me with the net sales and invoices for both days. I got the date
field and the net sales and invoices field from the same table.

The query works fine and all until I want to do some calcualtions in a
report. I set the report up to show the information on the report in
column form and on the footer section I created a SUM operator to
show the totals pf the net sales for both days but I also want to
create a total on the report that will show the DIFFERENCE between
the net sales for those 2 days. I cannot get it to subtract at all.
It always gives me a 0.00. (It takes the last net sales (the 2nd
date) and subtracts itsefl to get 0.00) I would like the Subtraction
to be like the sum and subtract both net sales and give me the
difference.

The query consisted of the date field with a simple OR criteria and
the net sales and Invoice fields too.
Click to expand...
Hi Scott,

It may be more complicated than I think,
but in your footer I think you know

- last net sales when enter footer = [NetSales]
-can compute Sum(NetSales)

so...what was the "first" net sales?

Sum(NetSales) - [NetSales]

what is the difference ("first" - "last)?

(Sum(NetSales) - [NetSales]) - [NetSales]

I think that sounds right, but I could be wrong...

good luck,

gary
 
Gary

Thank you very much!!! worked perfectly. I do have another questio
about time sheet issues but I will save that for another day. I ca
now finisih my report and database. Again, Thank you so much

Scot
 
Back
Top