Using crosstab query for a report

[Jon von der Heyden]

Hi,

I have a crosstab query and I've built a report to run off that. The crosstab fileds are automatically generated depending on the data entered into the master table.

I have a report that is bound to that crosstab and the fields are linked, but if I say delete some of the data from master, and one of the crosstab fileds disappears I get the following error:
"The Microsoft Jet database engine does not recognise '[Corporate Transformations]' as a vcalid field name or expression."

How do I change the text box to =0 if the field doesn't exist in the query?

Many thanks,
Jon

 

[CT Witter]

Try MS KB #328320 How to create a dynamic crosstab report in Access 2002

http://support.microsoft.com/kb/328320/en-us

Shows how to have a report that updates based on a crosstab query.

HTH,
CT

 

[Jon von der Heyden]

Awesome!