no results returned in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

These are my fields: event_id, LOC, GCS, and sample.
Now I am writing a query to return all fields when say
event_id=2 and LOC is null.

So what I did was in the criteria section I wrote.

event_id LOC
=2 Is Null

Now I know that there are fields like this in the
database, however when I run the query it returns no
response. Also if I remove the criteria for LOC and just
leave event_id=2, which there are many of those, I still
receive no results.

Can anyone help me figure out why? Much thanks!
 
Hi!

These are my fields: event_id, LOC, GCS, and sample.
Now I am writing a query to return all fields when say
event_id=2 and LOC is null.

So what I did was in the criteria section I wrote.

event_id LOC
=2 Is Null

Now I know that there are fields like this in the
database, however when I run the query it returns no
response. Also if I remove the criteria for LOC and just
leave event_id=2, which there are many of those, I still
receive no results.

Can anyone help me figure out why? Much thanks!
Click to expand...

Please open the Query in SQL view and post the SQL text here - it's
the complete query and may provide enough information to answer the
question. One possible issue: is Event_ID a Lookup field? If so, it
may not contain what you think it does, since the Lookup misfeature
will conceal the actual contents of the field!
 
Back
Top