Parameters and crosstab queries

[Pam]

I have set up a crosstab query with a parameter (i.e. entering the month) which is working fine for all months. Parameters have been set in both the criteria field on the design mode and also in the parameter section in the query. When I try to run a report based on this query it seems to get in a loop with the parameter on entering the parameter input when entering in 'Jan' in the design mode of the report. It eventually brings up all the correct data. When I enter in 'Feb' I am getting the following error .... "The Microsoft Jet database engine does not recognize <name> as a valid field name or expression. (Error 3070)". Help!!!

 

[Van T. Dinh]

It sounds like corruptions to me.

See if Tony Toews' article helps:

http://www.granite.ab.ca/access/corruptmdbs.htm

--
HTH
Van T. Dinh
MVP (Access)

I have set up a crosstab query with a parameter (i.e. entering the month)

which is working fine for all months. Parameters have been set in both the
criteria field on the design mode and also in the parameter section in the
query. When I try to run a report based on this query it seems to get in a
loop with the parameter on entering the parameter input when entering in
'Jan' in the design mode of the report. It eventually brings up all the
correct data. When I enter in 'Feb' I am getting the following error ....
"The Microsoft Jet database engine does not recognize <name> as a valid
field name or expression. (Error 3070)". Help!!!