count, and sum.

[chaosguy]

I have a query that filters records between two dates that a user enters. So now I wanna make a repot. A basic repot that just says how many orders are between those dates. A count of the records in other words. I also want the report to add up all the order totals and display that as well. Does anyone have any idea how i can do this? any help would be appreciated.

repot would look something like this
------------------------------------------------------

Number of orders this week (count of orders)

Total cost of orders (Total of orders)
------------------------------------------------------

and that's about it. The other stuff i want on the form i know how to do anlready, wellt hanks in advance.

Chaosguy - To die would be an awefully big adventure.

 

[ZmrAbdulla]

Two textBoxes in the Reportfooter
to count..
=Count([Orders])

to Sum
=Sum([Orders])


________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[chaosguy]

Do I use a wizard to generate the report or do I do this in designer view?

I'm tryign to do it in designer view, but how do i get the report to pull the values from the table, and if i do it in wizard, i would like get a whole big list of all the orders before i can get the total. It's kinda wasting paper even if i get what i want. any suggestions?

Chaosguy - To die would be an awefully big adventure.

 

[ZmrAbdulla]

Create a query and and a report by that through wizard..

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.