Editing out only certain Totals

[BLutgen]

I am creating an end of the month report. I have a query that gives me all of the information I need in the report. It is as follows:
Basic fields such as [qty],[model],[customer],etc. It also includes both [Cancel date] and [date on EOR report]. I then have four hidden fields. They are: Month([Date on EOR Report]) and Year([Date on EOR Report]) Both of these have Criteria with [Enter Month] and [Enter Year]. The other two are: Month([Cancel Date]) and Year([Cancel Date]) These two have their criteria in the OR field so that my query will search out items in both places. This works, but in the report it brings all of the information for the cancel dates including the original price. Therfore, when I want to get a balance for April, it is not only adding in the canceled cost, which took place in April, but also the original price that happened back in December. Therefore, the two offset themselves and my total stays the same. How do I fix this? I want only the canceled amounts of the canceled orders, not their original amounts as well. I will gladly provide any more needed information. Thanks.

 

[BLutgen]

What more information do I need, or what do I need to do differently to get a response to my question? I am new at this and any help would be great.

 

[JoeMiller]

Could you use another query and do DLookup's for the values you are seeking? Sometimes people get stuck in the "I can only get info from here" mindset and forget that whole Multi-RELATIONAL!-Database thing. What I'm trying to say is maybe you could have a query that groups the same as your report and does the calculation for you on the fields needed, and then use a DLookup function to go and retrieve the Sum field from your query.

HTH Joe Miller
joe.miller@flotech.net