|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 4th, 2005, 09:13 AM
|
|||
|
|||
Function isn't available in expressions in query expressions - hel
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? 
|
|
#2
February 4th, 2005, 10:42 AM
|
|||
|
|||
|
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....nceErrors.html -- HTH Van T. Dinh MVP (Access) "Icmeler" wrote in message ... 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?
|
|
#3
February 4th, 2005, 10:57 AM
|
|||
|
|||
|
Thanks for your help - my database is now working again.
"Icmeler" wrote: 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?
|
|
#4
January 30th, 2008, 09:33 PM
posted to microsoft.public.access
|
|||
|
|||
|
Function isn't available in expressions in query expressions -
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 "Icmeler" wrote: Thanks for your help - my database is now working again. "Icmeler" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Moving from xBase/Clipper | [email protected] | New Users | 1 | February 3rd, 2005 07:25 PM |
| adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
| Custom Function in a Select Query | Kirk P. | Running & Setting Up Queries | 5 | January 4th, 2005 09:27 PM |
| call the function query | Frank Dulk | Running & Setting Up Queries | 2 | November 15th, 2004 07:09 PM |
| Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Linear Mode
