summed values

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

Guest

I have a query that puts entries about the same item together. I have it
grouped by the dept, location, and the item. I then have the item price and
quantity summed. I also have the total price as the price * the quantity.
The query is what the report is based off of. When I go into the report to
show the information it still asks for the unit quantity as though the field
is missing something. However when I click the 'OK' button it gives me the
information that I'm looking for.

Is there a way to get rid of the "Unit Quantity" Screen that pops up when I
open the report?

Thanks,
Joe
 
Joe. Somewhere on the report you still have used "Unit Quantity", this could
be a formula or may be a count in the report footers, an other possibility is
that you may have grouped or sorted the report by the unit quatity. This is
assuming that when you open the source query you do not get the same prompt.
Hope this helps.
Fons
 
Back
Top