Very Computer

Dear All

Access 97

We have a database here that I am working on,  and on my machine it
won't produce graphs in the report with the query
I am using, yet on another machine the EXACT same query works.

Basically it comes up with an error message saying that "Function
isn't available in Query expression '(Format((Date of Check),"MMM \
YY"))'

However on the other machineit plots the graph no problem.

I thought it might have something to do with Referencing.  If you go
into the code window of access and go to Tools and Referencing there
seems to be a long list of extra controls for whatever is installed on
your machine, from Shockwave to IE5 etc, etc.

I realise you don't have the database to look at, but I can assure you
it is not an error in the query itself, its more like an option that
isn't installed on the computer, but I have installed everything
during the Office Installation.

Can you help me with this?

elric

well, did you actually check the references? if there's a problem,
you'll see MISSING: in front of the missing reference.

Quote:>Dear All

>Access 97

>We have a database here that I am working on,  and on my machine it
>won't produce graphs in the report with the query
>I am using, yet on another machine the EXACT same query works.

>Basically it comes up with an error message saying that "Function
>isn't available in Query expression '(Format((Date of Check),"MMM \
>YY"))'

>However on the other machineit plots the graph no problem.

>I thought it might have something to do with Referencing.  If you go
>into the code window of access and go to Tools and Referencing there
>seems to be a long list of extra controls for whatever is installed on
>your machine, from Shockwave to IE5 etc, etc.

>I realise you don't have the database to look at, but I can assure you
>it is not an error in the query itself, its more like an option that
>isn't installed on the computer, but I have installed everything
>during the Office Installation.

>Can you help me with this?

>elric