Compile error in query - HELP please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

datediff function compile error 3
Error msg - please help!! "Compile error. in query expression .." 1
#error - Blank 3
Formatting date gives bad results in query 2
query on date 1
DateAdd compile error 1
help in compile error 1
Date Function in query 3

Back
Top