If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter Bday list by month
I have a form where the persons name and birthday and the spouse name and
birthday and anniversary are entered. I want to be able to run a report and print all birthdays and anniversaries for the month of [Enter month] how would i set up the query / report to show this information? thanks in advance!! |
#2
|
|||
|
|||
Filter Bday list by month
Assuming that you have a field named "birthday",
add a column in your query design and enter: DatePart("m",[birthday]) AS Mth, tblMy Table.Birthday for the criteria of that same column, put: [Enter MONTH 1-12] -Ed "Breezy" wrote in message ... I have a form where the persons name and birthday and the spouse name and birthday and anniversary are entered. I want to be able to run a report and print all birthdays and anniversaries for the month of [Enter month] how would i set up the query / report to show this information? thanks in advance!! |
Thread Tools | |
Display Modes | |
|
|