A query to filter and sort

[Guest]

Hi, I have very little knowledge of Access or VBA but am trying to create a
query which will first filter according to a date range then sort the results
according to category so that they can be graphed by a report. For example,
my database could contain information on vehicle recalls with fields for
make, type, date of recall etc. I need a report that shows the # of recalls
per manufacturer during a user specified time period.

I have been using a drop down list within a form for users to select the
vehicle manufacturer and I have a query which will sum the # of recalls per
manufacturer BUT I can't figure out how to add the date filter.

Any thoughts?
TIA

 

[Jeff Boyce]

Create a new query. Add the table. Add the fields you want to see, select
by and sort by.

Under the date field you want to select by ("filter"), put the date in the
criterion. (or use a parameter if you'll be doing this repeatedly).

Under the category field you want to sort by, in the "sort" row, select the
sort (ASC; DESC).

Run it.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/