Records not being SELECTed

[glenellis]

Have an Access table with a status field. Field values are D - Deleted, R - Rejected, E - Exported, and blank. When I use the SELECT expert and click on the drop down on values, only D, R, and E are shown, although there are many records in the table where the value is blanks.

I need to SELECT records only where the status field is equal to blanks, but the SELECT returns no records.

 

[Nuffsaid]

Hi

Try this in the select expert;
{fieldname} isnot one of DRE
This should return the records you want (blank)

Hope this helps...

Nuffsaid

 

[glenellis]

Had to do with NULL values. Changed the formula to IsNull ({Requisition.Status}) and is working fine.

Thanks