Crosstab query with subquery

[StrikeEagleII]

I have a crosstab query that I am trying to filter what is counted based on a subquery
(TRANSFORM xxx SELECT xxx FROM xxx WHERE pkRevID In(Select xxx))...

I've seen in other posts that you have to add a parameter if your pulling a criteria from a form, but I keep getting the "Microsoft Jet database engine does not recognize 'tblTOLRevisions.fkTOLAircraftJoinID' as a valid field name or expression." As soon as I remove the sub query criteria from the query, it works fine (other than numbers are slightly off because it's picking too many records)

 

[dhookom]

Crosstabs just don't handle subqueries. You need to find an alternative.

Duane
Hook'D on Access
MS Access MVP