sorting by date

  • Thread starter Thread starter Fayette
  • Start date Start date
F

Fayette

HI

I have figured out with a lot of help how to design a query and make a
report. Two things I cant figure out

1. How to sort by date
for example to show August only
the date format is 00/00/0000

2 How to total each type of entry.
for example how many 4511.21's

Any input appreciated. I am very new at this so the simpler the better. This
will be a report I need to run each month

Thanks
Rick
 
1. This more like a filter rather than a "sort". Sort generally refers to
applying an order to the records. To display only August records add a
calculated field in your query
mth: Month([YourDateField])
and set the criteria to
8

2. You can sum any numeric field in a group or report header or footer by
using a control source like:
=Sum([MyNumberField])
 
Back
Top