Removing Blank Row in Crosstab Query

  • Thread starter Thread starter grantschneider
  • Start date Start date
G

grantschneider

I created a crosstab query where the first row is a count of all the
fields that are blank. I would like to remove this field from the
query.

Thanks,
Grant
 
I created a crosstab query where the first row is a count of all the
fields that are blank. I would like to remove this field from the
query.

Thanks,
Grant
Click to expand...

As well, there is another column that is labelled <> I am assuming
that is the count for all the blank fields but since it is a column it
needs a name. I would like to remove that as well. Though that can be
done in the report section if it is simpler than doing it in the
query.
 
Add the field that you are using as the value for the crosstab to the query
grid a second time.

Field: SomeField
Total: WHERE
Criteria: Is Not Null

That should remove all the records from the calculations where the field is
null. And it should drop the <> column from the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top