Function isn't available in expressions in query expressions - hel

[Icmeler]

I keep getting the following error message in a query that previously worked
for 2 years.
Function isn't available in expressions in query expression'Format([Billed
Month]),"mmm")
Does anyone know what this means?

 

[Van T. Dinh]

Likely to be corruptions in the References Collection of your database or
one of the References has gone missing or corrupted.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Icmeler]

Thanks for your help - my database is now working again.

 

[rkb]

I have the same problem, but the article referenced is no longer available at
that link. Does anyone have an updated reference to it, since it seemed to
have helped?

rkb

Thanks for your help - my database is now working again.

I keep getting the following error message in a query that previously worked
for 2 years.
Function isn't available in expressions in query expression'Format([Billed
Month]),"mmm")
Does anyone know what this means?