sorting by date

[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

 

[Duane Hookom]

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])