Search results

I'm sorry I tought it was the same code.

I am making a dynamic report with a crosstab query. My problem is that the report need to have changing headings. I looked on this site and many others, to find a solution. But I still havent found one. I put here my code in the hope someone knows what the problem is in my VBA-code. Thanks...

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

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

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

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

Thanks, but this has fixed headers, mine need to change.

I meant head. The rest of your post I don't understand.

The problem is that the headers need to change to.

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...

Hi everyone I'm trying to make a matrix in a report. The heats and rows have to change all the time. This is a problem in a report, because the rows can chage, but the heats don't. I have tried making it with a crossquery. But I need to change thing in the heats, and this also doesn't work...