G
Guest
I have a table (Test) with 2 fields - Centre and Type, that have look up's to
other tables - Centres table and Types table. I am trying to run a query
that would return records where no centre is identified. I have tried using
IsNull, Isempty, ismissing and the below, but nothing seems to work. Any
suggestions, assistance would be greatly appreciated
SELECT Test.CentreId, Test.TypeId, Test.Name
FROM Test
WHERE (((Test.CentreId)=""));
other tables - Centres table and Types table. I am trying to run a query
that would return records where no centre is identified. I have tried using
IsNull, Isempty, ismissing and the below, but nothing seems to work. Any
suggestions, assistance would be greatly appreciated
SELECT Test.CentreId, Test.TypeId, Test.Name
FROM Test
WHERE (((Test.CentreId)=""));