Problem with Crosstab Query and Report

[Guest]

I've got a problem that I can't seem to solve. I've got a form that I use to
input a date range for a crosstab query. The results of the crosstab query
are then displayed in a report. The query works just fine and I've got my
parameters defined, column headings specified, etc. When I try to run the
report, I get an error message stating "The Microsoft Jet database engine
does not recognize " as a valid field name or expression". I have a copy of
this database on my harddrive and everything works fine. When I copy it out
to a server and relink all the tables, the report no longer runs. Any
thoughts? Thanks.

 

[Guest]

No need to respond. I copied a similar set of forms/queries/reports that
were working and was able to overcome this issue. Not sure why it was
happening but it works now.