Format$ error ?????

[Ian Tranter]

I have ea query that formats a date field using Format$()
as follows:
Date By Month: Format$([Date Received],"mmmyy")

We have 5 workstations all configured the same (or so I
am told they are) but on 2 of them I get the error
message: -

Undefined function 'Format$' in expression.

Anyone explain what is going on here & how do I update
the 2 workstations to fix the problem or how do I fix the
query.

Actual query: -

SELECT Format$([Date Received],"mmmyy") AS [Date By
Month], Enquiries.[Enquiry #], Count(Item_Det.[Part #])
AS [CountOfPart #]
FROM Enquiries LEFT JOIN Item_Det ON Enquiries.[Enquiry
#] = Item_Det.[Enquiry #]
GROUP BY Format$([Date Received],"mmmyy"), Enquiries.
[Enquiry #], Item_Det.Complete
HAVING (((Item_Det.Complete)=0))
ORDER BY Enquiries.[Enquiry #];

Any help greatly appreciated J))

 

[Allen Browne]

Those machines have a problem with their references.

Press Ctrl+G to open the Immediate window.
Choose References from the Tools menu.
Any of the checked references showing "MISSING"?

More info:
http://allenbrowne.com/ser-38.html