I get this sign <> in my query

[AGOKP4]

Hi all,

I get this sign <> in my query...what does it mean and how can I get rid of
it?


Thanks!!!

 

[John Spencer]

GUESSING here. You did not say where you see "<>" such as in value returned
in a field, a field (column) title, etc.

So assuming that you are using a crosstab query and that sign is appearing as
a column header then the <> means that the values that are being used for this
column is NULL.

You can get rid of it by using a where clause that screens out null values in
the column. In query design view, add the field you are using for Value and
change the total to WHERE and set the criteria to Is Not Null.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[AGOKP4]

It did work...thanks. It was in a cross tab query as a column header