need help

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

Guest

I have a report that I need help on
I have a query with the following fields
Vendor number
theMonth-Criteria the month I want- but I don't want to go in and change it
everytime
Date Received-is not null
Open "open"

I want to open 1 report and it to look like
December 05 452
January 06 500
February 06 495
March 06 0

Or something similar.
Thanks for all your help
 
well you don't give the layout of the table so one can't be sure of the
correct response....but generally speaking if the Month Criteria is indeed a
separate field then one easy thing to consider is to use the Grouping icon
from the tool bar of your Report in design view....when that is open select
the Month field and then on the right side just select Ascending or
Descending.....

you don't have to go in and change the criteria....everytime you open the
report it will be sorted by Month......

seems like you have or need a Count function too but maybe you already have
a handle on that.......
 
Back
Top