trouble with query

[hiya5150]

i'm trying to create the following query:

from donation records i want all those records that have t05 in the donation type but not those that have '2005' in the memo field. now, if i type 'not like 2005' in the criteria for memo and t05 for the donation type field, i only get those fields that have something in the memo field, something other than 2005. in other words, i'm not getting the records with null value in the memo field. i've tried several things, but i can't make it work. please help!

 

[M8KWR]

Change your memo criteria to:

Not Like "*2005*" Or Is Null

hope this helps

 

[MzKitty]

Nest your if's:
if type = "t05" then
if memo not "2005" then
etc
This way you'll select all the t05 records first then you can sort out the memo 2005 records.

Cathy

 

[PHV]

WHERE Nz([memo field]) Not Like '*2005*' AND [donation type]='t05'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hiya5150]

i've tried all of your suggestions(before i posted my message). the problem is that if i put in 'not in 2005' and is null, it filters all the records that have something other than 2005 in memo.


as for mzkitty's suggestions, i'm not so familiar with slq, perhaps you can write it out, i'm not sure where to put my ifs. thanks.

 

[hiya5150]

anyway, since i didn't want to try the 'if' idea, i would have to dig up my access book for that, i figured out another way. i typed NOT LIKE '2005' OR IS NULL. it's the only way i could make it work.

thanks everyone. Heidi.

 

[M8KWR]

Like i said earlier????? !!!!! ??????

 

[hiya5150]

you're right. in hindsight, i realized that i entered not like 2005 on one line and is null and the other line. which seems to be why it excluded all the other records that fit the 'is null' criteria.

thanks.