If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
no results returned in query
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! |
#2
|
|||
|
|||
no results returned in query
On Mon, 21 Jun 2004 09:22:25 -0700,
wrote: 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! 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! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|