How to remove group heading fm page top?

[Yu2008]

Hi, I am a newbie to Access ( just one week). Trying to create a report from the cross tab query for a warehouse report but got a problem:

a blank group heading kept appeared on the top of the 1st page. I try to remove it by select function like "invisible" or "delete", but if I do so, the group data which I need in the report will disappear also.

Attached is what this report appear like, Can someone tell me how to remove this group heading on the page top? (just on the 1st page where the blank total subtoal are, and as you can see there is no such heading top on the 2nd page which is what I like). Thank you

 

[pbaldy]

Is the query returning a blank record? It seems more data related.

 

[Yu2008]

Hi Paul,

The query-crosstab returns good result though... I attach it here for your reference ... maybe there is some clue you can find it from there?

Thanks !

Yu

 

[Yu2008]

Hi Paul, just after I send out the last email to you. I realized that the first row of the crosstab query is blank, maybe that blank top of report is because of this? ....... But where does this empty row on the crosstab query come from? and I culdn't get rid of it from the query.....

 

[pbaldy]

I believe that's the issue with the report, yes. It's coming from the data. Perhaps adding a criteria to the query that eliminates that record (or records with a Null product class).

 

[boblarson]

You have to find the blank record in the data, or change the query so that nulls and empty strings are not selected.

 

[Yu2008]

Hi, I finally figure this out. Yeap, it is all due to the nulls in the data.

Pual, Bob, thank you for all your help! It is a warm family here : )

Yu

 

[pbaldy]

Glad we were able to get it sorted out for you.