A aymanmb Registered User. Local time Today, 02:42 Joined Jan 28, 2007 Messages 96 Mar 4, 2007 #1 I have created a cross tab quarterly query to sjow the 4 quarters sales. Problem is if there is no sales in one of the quaerters, the report based on that query gives an error as per attached photo and do not open. any work around Attachments untitled.JPG 19.8 KB · Views: 283
I have created a cross tab quarterly query to sjow the 4 quarters sales. Problem is if there is no sales in one of the quaerters, the report based on that query gives an error as per attached photo and do not open. any work around
P Peter Reid Registered User. Local time Today, 00:42 Joined Dec 3, 2003 Messages 134 Mar 4, 2007 #2 Look at the 'Column Headings' setting in the 'query properties' of your crosstab query Only the field names entered here (seperated by a comma) will be displayed in your crosstab query e.g. "Qtr 1","Qtr 2","Qtr 3","Qtr 4"
Look at the 'Column Headings' setting in the 'query properties' of your crosstab query Only the field names entered here (seperated by a comma) will be displayed in your crosstab query e.g. "Qtr 1","Qtr 2","Qtr 3","Qtr 4"
