expression problem in query (1 Viewer)

[pherms]

I have build a query in access which contains an expression.
The expression is something like this:

formatdate([field_name],"mmm")

When I run this query, access comes with an error similar to this:

error in expression formatdate([field_name]),"mmm")
This error occurred when I installed windows xp with office 2000.
I have all the windows updates installed and also office 2000 sp3 and all the updates. I also have Mdac 2.8 and jet 4.0 sp8 installed.

I didn't have any problems with windows 2000 and office 2000.
My colleague said that this was corrected by installing a patch. Unfortunately he couldn't remember which patch it was.

Please help

 

[Lister]

formatdate([field_name],"mmm")

Just got the function wrong by the looks of it.
Try
format([field_name],"mmm")

Should do the trick

Hope this helps

 

[pherms]

Well, I encoutered the problem yesterday at work. I was at home when I posted this thread, so I couldn't exactly remember how the expression was built, so I asked my collegue, who built the database, and asked him how the expression was built.

This is how:

format([verkoop datum],"yyyy")

This is also where he get's the error. As I said, this error occurred after I upgraded his pc to windows XP.

 

[Rich]

I suspect you have a missing/broken reference problem, try refreshing them