Cross-Tab Query

T

Ted

I'm working with a cross-tab query that is based on a
select query. The select query has a from/to range
criteria. (Between [Enter Starting Store] And [Enter
Ending Store])

The cross-tab returns an error indicating that it does not
recognize [Enter Starting Store] as a vaild field or
expression.

Why does the cross-tab have a problem with this type of
criteria?
 
J

Joan Wild

Crosstab queries require that you define the datatype for any parameters.
Go to Query, Parameters and put
[Enter Starting Store] and specify the datatype and repeat for [Enter Ending
Store]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross-tab queries 8
Error on a cross-tab query 1
Want a Parameter for date range driving a cross tab query 2
Cross Tab Report Vs Dynamic coulmns 0
Cross-tab query 2
crosstab query with datea parameters 2
Report Parameter Value 4
How to resolve problems where Msoft Jet Database does not recognis 1

Top