AC5FF
Registered User.
- Local time
- Yesterday, 21:57
- Joined
- Apr 6, 2004
- Messages
- 552
I am trying to modify an existing program and have run into difficulties... I'm new at working with VB but roughly understand what is happening.
I'm only having issues with one WHERE clause ... I am pretty sure if I can modify this where clause correctly I can figure the rest of this program out. It is just killing me that I can't make it past this one step!! :banghead:
Forgive me, but I don't have access to the program currently, i'm going off of memory. My current where clause looks something like this:
WHERE table.IA = "Yes"
Having this line in the program returns 2 results - as expected. However I need to query different fields, so I've re-written my where clause to:
WHERE table.Status = "Active"
This line will return 209 results - again this is expected and correct. However I have to narrow this even further, so I then added:
WHERE table.Status = "Active" AND table.dcc <> ""
This now returns 0 results. The dcc field is a text field with data that would look like DCC-001, DCC-002, etc... Some records are blank, and those are the ones I wish to ignore. Out of the 209 "Active" records, only 69 have DCC entries.
I've tried DBNUL, ISDBNUL (I think spelling here is right) and a few other variants without any luck. I've even tried using a wild card like table.dcc = "DCC*" ... Not sure if that is even allowed, but figured I would try it. Again, no luck.
Thought I would ask here because I've gotten great help in the past with normal Access queries/etc issues I have run into.
Any Ideas??
I'm only having issues with one WHERE clause ... I am pretty sure if I can modify this where clause correctly I can figure the rest of this program out. It is just killing me that I can't make it past this one step!! :banghead:
Forgive me, but I don't have access to the program currently, i'm going off of memory. My current where clause looks something like this:
WHERE table.IA = "Yes"
Having this line in the program returns 2 results - as expected. However I need to query different fields, so I've re-written my where clause to:
WHERE table.Status = "Active"
This line will return 209 results - again this is expected and correct. However I have to narrow this even further, so I then added:
WHERE table.Status = "Active" AND table.dcc <> ""
This now returns 0 results. The dcc field is a text field with data that would look like DCC-001, DCC-002, etc... Some records are blank, and those are the ones I wish to ignore. Out of the 209 "Active" records, only 69 have DCC entries.
I've tried DBNUL, ISDBNUL (I think spelling here is right) and a few other variants without any luck. I've even tried using a wild card like table.dcc = "DCC*" ... Not sure if that is even allowed, but figured I would try it. Again, no luck.
Thought I would ask here because I've gotten great help in the past with normal Access queries/etc issues I have run into.
Any Ideas??