Trouble With Crosstab Query

[Kriis]

This is my first time posting here and I hope you guys can help me.


I have a problem with using a crosstab query.

My original table looks something like this

VALUES
Oil_ID (PK)
Property_ID (PK)
Col_Heading (PK)
Row_Heading (PK)
Values
Oil Name
Property Name

I made a crosstab query with the columns being 'Col_Heading' and the rows being 'Row_Heading' and the values being 'Values'.

I made a form that has two combo boxes (Oil Name, Property Name). It also has a subform in which I want to display the crosstab query.

Now here comes the problem. Those two combo boxes need to be able to filter the data, but I am not able to put the code:

IIf(IsNull([Forms]![Values Form]![combo52]),[VALUES].[Oil Name],[Forms]![Values Form]![combo52])

IIf(IsNull([Forms]![Values Form]![combo66]),[VALUES].[Property Name],[Forms]![Values Form]![combo66])

in the Criteria because an error pops up saying: "The Microsoft Jet database engine does not recognize 'above_code' as a valid field name or expression.

So I created a select query, call it QueryA', that would let me filter the data. The I created a crosstab query based on QueryA, but the same error message occurs.

I am stuck. If you could help me, I would greatly appreciate it.

Thanks

 

[Kriis]

http://www.access-programmers.co.uk/forums/showthread.php?t=102156

Should've read the forum first.

Thanks