Crosstab Queries in MS Access

[bondidude]

Hi,

I am trying to run a crosstab query which has input from a form as criteria in its where clause, but I keep getting told that the 'Microsoft Jet Database doesn't recognise [Forms]![Form Report]![Cert] as a valid field name'.

I find this strange seeing as I have form fields as criteria in a number of non cross tab queries.

Has anyone come across this?

 

[Steve101]

Try using the Query, Parameters menu option, and defining the [Forms]![Form Report]![Cert] as a parameter. I sometimes find that crosstabs are a little fussy with wanting these parameters defined.

PS. Is that "bondidude" as in Sydney, Aust? Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[bondidude]

Thanks Steve, that worked a treat.

I hadn't come across parameters before.

Incidentally, yes Sydney, Aust would be correct.

Cheers

Nik