Compile error in query - HELP please

P

PegGall

I have the following expression in my query: DOB_MM: Format([BIRTH_DT],"mm")
and I have verified that my field, BIRTH_DT is defined as a Date/Time field.
The problem is that I get a compile error on this every time I try to run it.
I have replaced the BIRTH_DT field with DATE() and I get the same error. Any
help would be appreciated as I am very frustrated and need to get a project
completed.
 
J

Jerry Whittle

I bet that you have a broken reference. Go to the following web page for
information on checking references:

http://www.mvps.org/access/bugs/bugs0001.htm

Also the Format function returns a string while the Month function returns
an integer. Depending on what you are doing with the DOB_MM field, you might
consider something like:

DOB_MM: Month([BIRTH_DT])
 
Top