Parameters and crosstab queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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)



Pam said:
I have set up a crosstab query with a parameter (i.e. entering the month)
Click to expand...
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!!!
 
Back
Top