Re: I get this sign <> in my query
- From: John Spencer <spencer@xxxxxxxxx>
- Date: Mon, 20 Jul 2009 11:12:20 -0400
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 wrote:
Hi all,.
I get this sign <> in my query...what does it mean and how can I get rid of it?
Thanks!!!
- Follow-Ups:
- Re: I get this sign <> in my query
- From: AGOKP4
- Re: I get this sign <> in my query
- References:
- I get this sign <> in my query
- From: AGOKP4
- I get this sign <> in my query
- Prev by Date: I get this sign <> in my query
- Next by Date: Dmax Function (I think!)
- Previous by thread: I get this sign <> in my query
- Next by thread: Re: I get this sign <> in my query
- Index(es):
Relevant Pages
|
