MS Jet Database Error 3070 (97)

Topic

New Reply

I am confused.
1. I have created a Base query.
2. I created a crosstab query based upon the Base query.
3. I created a report based upon the crosstab query.
4. All worked fine.
5. Now I have created another crosstab query based upon the original Base query.
6. This crosstab query works fine.
7. Now the new report based upon this new crosstab query does not work: I keep getting this error message that does not make sense to me:
The Microsoft Jet database engine does not recognize as a valid field name or expression. (Error 3070)
The field is BaseQuery.LastName

What’s up?????

Louis

Reply | Quote

Replies

Could it be something in your grouping/sort selections in the report?

Reply | Quote

It does not appear to be that.
After trying it a number of times, opening in design, saving, running it, and adding a field in design, I finally got it to work.

However, when i tried to talk a friend thru the process over the phone, she got the same results.
Can’t figure it out.

Soc

Reply | Quote

Just run the query and look at the column headings. If one of them is BaseQuery.LastName, rather than just LastName, that could be your problem.

On the other hand, crosstab queries as report datasources can cause problems, especially if there’s a parameter somewhere in the mix. Since crosstabs are dynamic queries, they normally only return columns where data exists You might try setting up column headings in your crosstab so that the columns will always be returned even if no data exists for them and see if that cures your error.

Reply | Quote

The MS Knowledge base has this article for Access 2000 but I think that it applies to A97 as well
http://support.microsoft.com/support/kb/ar…s/Q209/7/78.ASP

Reply | Quote