Question

List the name, type, breed and date of birth for all cats or dogs born after January 1, 2000. The data should be sorted by date of birth (ascending).

I have a database with a few tables. And while creating a query, this is one of my questions. I do not know how to filter my data in this table by the date

MS ACCESS

Answer 1

Filtering is a useful way to see only the data that you want displayed in Access databases. You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query.

There are several types of filters and some of them are easy to apply and remove. Access contains some common filters that are built into every view. The availability of filter commands depends on the type and values of the field.

to view the records of people whose birthdays fall during a specific month, click the BirthDate column, on the Home tab in the Sort & Filter group, click Date Filters, and then select the required date period.

if you have any other question about MS access or even MS Excel than comment on the answer and i will provide you the solution.