Format error after conversion

[Martyn Griggs]

I've converted a database from Access 2000 back to Access
97, all works OK apart from one column which I added to a
query to extract the year from another column in the query
called Profit Period. The expression for the new column
I've entered is: Profit Year: Format$([Profit
Period],"yyyy"). This works fine in 2000, for example for
01-Mar-2003 it returns 2003 into this column, but after
converting to 97, it returns #Error and the query then
prompts for parameter for yyyy, which I don't want it to
do. Anyone have any ideas? Thanks for your help.

 

[Joan Wild]

Sounds like a missing reference.

See
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Joan Wild]

Sounds like a missing reference.

See
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html