I have a database that was created in Access 2000 and I am now using in 2003.
If I try to use a function such as Format or write an expression in a query
such as =right to use the right portion of a data field I get error messages.
I can created a new database for test purposes and these functions and
expressions work fine. Where do I look for my problem? I can't seem to find
the answer in Microsofts support pages.

Sounds like a problem with references.

Press Ctrl+G to open the Immediate Window.
Choose References on the Tools menu.
Any checked libraries marked "MISSING"?

More info about the libraries you need for your version of Access:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Engineer" <(E-Mail Removed)> wrote in message
news:A2301E9E-F920-46DB-853D-(E-Mail Removed)...
>I have a database that was created in Access 2000 and I am now using in
>2003.
> If I try to use a function such as Format or write an expression in a
> query
> such as =right to use the right portion of a data field I get error
> messages.
> I can created a new database for test purposes and these functions and
> expressions work fine. Where do I look for my problem? I can't seem to
> find
> the answer in Microsofts support pages.