Cross-Tab Query

  • Thread starter Thread starter Ted
  • Start date Start date
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?
 
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]
 
Back
Top