Question

Make a parameter query thats allows the user to choose which birth month to display,. So when the use is prompted for birth month, they might type 3, for March, and only the records which have a Date of Birth (dd/mm/yyyy) in March, will display

Answer 1

The structure of the table is shown in the figure:

The query in query design:

SQL:

SELECT customers.Last, customers.First, customers.DATE_OF_BIRTH,
Month([DATE_OF_Birth]) AS month_of_birth
FROM customers
WHERE (((Month([DATE_OF_Birth]))=[Enter the month of birth]));

Query result:

Answer provided by AssignmentExpert.com