Removing Blank Row in Crosstab Query

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

John Spencer

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