An Access Query Question on Finding Blanks

June 8, 2010 at 11:58:18
Specs: N/A
I have two tables in Access and I want to find which of A has no B.

TABLE MAIN, only field being used for query, ID.
TABLE ITEM, only field being uses for query, ITEM.

I am trying to find which ID entries have no, as in blank, ITEMs.

My query looks like this:
===============================
ID is linked to both tables.

Field....ID......ITEM
Table....MAIN....ITEM
Criteria.........Is Null
===============================

What happens is I get nothing, as in no results, when I am using the query above.

Any help would be great, thank you.

Christian; warrior; GSPer; Borg; ninja; Time Lord... I am that hero! La resistenza è, ed è stato sempre, inutile.
I reply as fast as I can but could be hours or months.


See More: An Access Query Question on Finding Blanks

Report •


#1
June 8, 2010 at 13:30:40
Post your SQL

Report •

#2
June 17, 2010 at 07:11:05
I was able to find it using the relationship of the fields using option #2, that is able to distinguish. Thank you thought for responding. Very much appreciated.

Christian; warrior; GSPer; Borg; ninja; Time Lord... I am that hero! La resistenza è, ed è stato sempre, inutile.
I reply as fast as I can but could be hours or months.


Report •

Related Solutions


Ask Question