Crosstab query invalid field name or expression

[JessicaVdb]

Hi

I am making a crosstab query. There are two rows that need to be changed trough a combo box on a form. I have '[Forms]![Form1]![TankType]' by the criteria. And also a parameter like this 'ThankType Tekst (255)'.

Stil I get that Microsoft Access database engine does not recognize '[Forms]![Form1]![TankType] as a valid field name or expression.

What is the solution for this problem?

Thank you
JessicaVdb

 

[JHB]

Show the SQL string.

 

[JessicaVdb]

 

[isladogs]

1. Is there a space before Q? If so, wrap table name in []
2. As far as I can see, there's no mention of a form in the crosstab query
3. MaxOfMaxOf... looks dubious
4. Does it work if you remove the parameter line?

Please re-post this using the code tags so it can be edited by one of us.

 

[JHB]

You're not using the parameter in a criteria.

 

[JessicaVdb]

1. Is there a space before Q? If so, wrap table name in []
2. As far as I can see, there's no mention of a form in the crosstab query
3. MaxOfMaxOf... looks dubious
4. Does it work if you remove the parameter line?

Please re-post this using the code tags so it can be edited by one of us.

1 There is no space
2 Where do I need to mension it?
3 Changed
4 Not working then

 

[JessicaVdb]

You're not using the parameter in a criteria.

Now I have.

Between From and Group by stands now 'WHERE (((AllShiftLinePic1Q.TankType)=[Forms]![Form1]![TankType])))

 

[JHB]

Now I have.

Between From and Group by stands now 'WHERE (((AllShiftLinePic1Q.TankType)=[Forms]![Form1]![TankType])))

Should be:

(((AllShiftLinePic1Q.TankType)=TankType)))

Else post you database, zip it.

 

[JessicaVdb]

Should be:

(((AllShiftLinePic1Q.TankType)=TankType)))

Else post you database, zip it.

Doesn't work eather. I'm sorry but this is a database from my work, I can't put it on here.

 

[JHB]

Doesn't work eather. I'm sorry but this is a database from my work, I can't put it on here.

You don't need to put the whole database on here, create a new database, create/import the table "AllShiftLinePic1Q" and insert some dummy data + the form and the query.

 

[JessicaVdb]

Thank you everybody for helping, but I fixed the problem myself.