Queries in 2002 (2002)

[Bret Graham]

I have a dilema. I can't seem to grasp the differences between 2000 and 2002. I need to create a query in a DateTime field that will return the dates in mm/dd/yyyy format. They way I used to do it Date: Format([DateTime],"mm/dd/yyyy") does not work. I get the error message "Undefined function '[Format$]' in expression"

I guess from what I have been able to read in the HELP section I need to learn SQL. Along with the answer for the above question, does anyone know a good SQL reference?

TIA
Bret

[charlotte]

Are you in an MDB or an ADP? If you're in an ADP, you aren't building queries, you're building views and stored procedures in SQL Server and SQL Server doesn't recognize Access/VBA functions. If you're in an MDB, you've got a references problem.

[Bret Graham]

I am in mdb. The thing that is strange is, all these queries worked/work in Access 2000. But when I upgraded on this one machine, now I have started getting these error messages.

Thanks.

Bret

[WendellB]

As Charlotte said, the problem is not with your queries - it has to do with references. Go to the modules tab and open any module in design mode, then select Tools/References and you should see either some missing references, or you may see no reference to DAO, and a reference to ADO instead. Compare what you see on an Access 2000 machine with what you see on the Access 2002 PC, and change the 2002 PC to be the same as the 2000 PC.

[Bret Graham]

When I go to the Modules tab there isn't anything listed. Just to give you a little background. These queries are from tables that are linked to a software program that uses Access as the data storage device.

I don't know if this makes any difference to what you are trying to help me with or not.

TIA
Bret

[Francois]

What Wendel and Charlotte means is the following.
Open a module in design view.
If there is no module create a new one.
In this module, select the menu Tools, References.
You will get a window like the picture below.
Look at the list if you find near one of the check boxes the word MISSING
It this is the case, the uncheck this check box.
Close the module. (you don't need to save it).