Adding criteria from a combobox to multiple crosstab queries

[stlciao]

I am having a problem adding criteria to a multiple queries using a combo-box on a form to enter two dates that I want to compare the data from each date.

I am importing about 50k to 60k rows of data each day that I want to calculate a variance with a prior day (sometimes the previous day, sometime a weekly variance or Monday versus Friday). I load the data into a table and then use three queries that separate the data into three segments [Segment1], [Segment2], [Segment3] and use a [Begin Date] and [End Date] from a combo-box on a form in the criteria to select the dates of the data I want to compare. Then I have four crosstab queries that are based on each Segment query. However, the crosstab queries will not run and I will get an error "The Microsoft Jet database does not recognize '[Forms]![Start Forms]![Begin Date] as a valid field name or expression." However, this combo-box address is only in the segment query criteria and is not in the crosstab query. The segment queries will run fine when ran individually.

Previously, I used >now()-8 as the criteria in the segment queries and the crosstab queries would run, however, it exported additional data to excel which I would manually have to delete.

Any possible solutions would be appreciated...
Thanx

 

[Dugantrain]

I know that Crosstab Queries are much pickier about accepting parameters than normal Select Queries. In Query Design, right-click, go to Parameters and then define the parameter there as well as in the Criteria section. I seem to remember that you should take your parameter out of the original Select Query that feeds this Crosstab and only have it in the Crosstab, but I'm not sure; it's been a few months since I encountered this problem.

 

[stlciao]

That did the trick...

Thanx for your help...