how do i define in my query the birthday celebrants for the existing month so that when someone prints the birthday celebrants report, all celebrants for the existing month only will be shown? help! thanks!

Ella. Select the month you want in your select query that is the basis for your report. e.g.

SELECT tblYourTableName.YourDateFieldName
FROM tblYourTableName
WHERE ((([Enter month])=Format([YourDateFieldName],"mmmm")));

David

hi djn,

where exactly will i paste that code? i'm sorry it's the first time i'll be doing this. thanks so much!

ella

Ella,

DJN overlooked the part in your question "for the existing month".

Use this SQL statement:

SELECT tblYourTableName.YourDateFieldName
FROM tblYourTableName
WHERE DatePart("m", Date())=DatePart("m", tblYourTableName.YourDateFieldName);

Open Access, create a new query in design view. Copy the code replacing it with your table name and field name.

Save the query.

Suc6,

RV

I tried defining this in the criteria based on my research from this site:

Between [Enter Start Month & Day mm/dd] And [Enter Ending Month & Day mm/dd]

The prompt worked, however, it's not giving back accurate results. What shall I do? Where did I go wrong?

hi RV,

i was able to execute your suggestion and it worked wonders.

thanks a million http://www.access-programmers.co.uk/ubb/smile.gif