How do I put in date criteria to search for birthdays within a pa.

[Guest]

I am a novice. Please help. What wildcard is used for the year in a date
field? I am trying to query for birthdays in a particular month for the
employees.

Thanks

 

[Rick B]

Add a new column to the query like...
BirthM: Format([BirthDateField],"mm")

in the criteria put...
= [Enter Month in the format MM]



Hope that helps!


Rick B

 

[Guest]

se my reply 2 messages below "each month for a query"

Madhouse

 

[Guest]

Presumably you are constructing filter clauses to pass to the report? If so
then if user has not seleceted in combo and combo has no default value its
value will be Null. So when constructing your filter clause you can do
something like...

If not IsNull(combo_field) then
filter_string = "column_name = " & combo_field
else
filter_string = ""
end if

Madhouse

Add a new column to the query like...
BirthM: Format([BirthDateField],"mm")

in the criteria put...
= [Enter Month in the format MM]



Hope that helps!


Rick B

I am a novice. Please help. What wildcard is used for the year in a date
field? I am trying to query for birthdays in a particular month for the
employees.

Thanks