Format$([Date]) error, help please.....

[efinnen]

I have a table which I'm incorporating into a query. There are numerous fields in a date format. I want to get a field in the query that groups the dates to just a month and year. I.E. Records with 12/01/97, 12/11/97 and 12/27/97 all will come across with December 1997.

I used the following command in the query builder
Format$([Date], 'mmmm yyyy')

The query works splendidly on 5 machines and not two others. The problem arises in that one of the non-functioning machines is the clients.

The query was written on A windows 2000 machine with a complete (all bells and whistels intsall of office 2000) and one of the one's it doesn't work on is another Win2000 machine with an identical installation of Office 2000. Any help or guidance would be appreciated! Or anotehr approach in regards to solving the issue.

Thanks
-Eric

 

[JerryDennison]

It could be the infamous References issue. There are several functions that are affected by this known problem, Format() being one of them. Have the users open a module, any module; goto Tools... References... They should check the order of references and compare with those machines that work. Also, they should select any reference that isn't selected, close the module, re-open the module, go back to references and uncheck the one they just checked, close the module again and then retry the queries. This should take care of the problem. You can also programmatically check for this error and attempt to correct. You can find this on the MS help site. (sorry I don't have the URL or I'd give it to you)