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

On Jul 11, 12:44 pm, grantschnei...@gmail.com wrote:
> 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

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

<grantschneider@gmail.com> wrote in message 
news:1184154395.248506.323400@57g2000hsv.googlegroups.com...
> On Jul 11, 12:44 pm, grantschnei...@gmail.com wrote:
>> 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
>
> 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.
>