Access help

[AdamSnow]

I have an access database that stores a birthday in the form of mm/dd/yyyy...

How would I make a report that only display's people who's birthdays are in April... or July, etc... ?

 

[EagleKeeper]

Originally posted by: AdamSnow
I have an access database that stores a birthday in the form of mm/dd/yyyy...

How would I make a report that only display's people who's birthdays are in April... or July, etc... ?

Build a query that requires external input and use the input as some type of filter.
The input could be from arequest to the user or a seperate table field where the filter info is stored.

 

[KLin]

Build a query with criteria like the following

Between [Please enter beginning date] and [Please enter ending date]

Make the query the datasource of the report. When you run the report it will prompt for a beginning date and an ending date before running.