Date format query

[Spelthorne1]

I have a table with a date field eg. '02/03/2004' and have written a query to convert this into a format of just the month eg. 'March' using the following query in the field. 'Format date: Format([date],"mmmm")'

This use to work on two PC's using this database, but now only works on one. Any suggestions as to why? I am getting an error message 'Function is not available in expression in query expressions 'Format([date],"mmmm")' '

 

[Rich]

You have a missing reference, search here for solutions if you don't know how to fix

 

[Spelthorne1]

Solution

Problem Solved: For some strange reason the Reference Library could not locate a dll file from the Windows Media Player. I re-installed WMP and re-selected the WMP from the Referenence Library and then the 'Format' command now works! Hey its a mad world out there.