How would I build this report?

  • Thread starter Thread starter Rusty Shackelford
  • Start date Start date
R

Rusty Shackelford

I want to build a report that does just a summary of the report. Lets say a
query selected all the records from a date range I wanted from a table
called orders. And each order record had a few classifications, one would be
a type of order (cash or credit), then I have check boxes for different
additional information (returning customer, walk in, or senior citizen). The
report I want to make would first separate the cash from the credit and give
a total number of orders for each. Then I would want cash and credit broken
down into a number for each of the other additional information that make up
the cash or credit. Not sure the best way to proceed on this. Any links to a
good guide would be grate or any suggestions.

Thanks
 
Sounds like you want to have a group for Cash/Credit with a group footer.
In the footer, you can total the records. The detail section would contain
notheing or at the very least be marked visible=no.

Rick B


I want to build a report that does just a summary of the report. Lets say a
query selected all the records from a date range I wanted from a table
called orders. And each order record had a few classifications, one would be
a type of order (cash or credit), then I have check boxes for different
additional information (returning customer, walk in, or senior citizen). The
report I want to make would first separate the cash from the credit and give
a total number of orders for each. Then I would want cash and credit broken
down into a number for each of the other additional information that make up
the cash or credit. Not sure the best way to proceed on this. Any links to a
good guide would be grate or any suggestions.

Thanks
 
How would I count the numbers of trues int the check boxes for each of the
aditional criteria?
 
I got it to work had to do =SUM([FIELDNAME]) then for some reason it came
out as a negative number so then it looks like this =SUM([FIELDNAME])*-1.
Again this was for summing true or false
 
Back
Top