Query Criteria (Access2000)

Topic

New Reply

I have the following problem. I have few feilds (Date, Name, INTL_SHARE, SFM_1, SFM_2) in a query. What I want to do is display INTL_SHARE ONLY when SFM_1 OR SFM_2 are not empty. I don’t know how to write a criteria for this. Any help?

Reply | Quote

Replies

Have you tried using ‘Is Not Null’?

Reply | Quote

ya but that doesn’t work with what I want to do. I want something like: Not Null = SFM_1 Or SFM_2. I tried that too but it looks like I add anything to Is Not Null or Not Null criteria.

Reply | Quote

Try putting all three fields in the query grid. Uncheck the Show check boxes for SFM_1 and SFM_2. On the first criteria line for SFM_1, type Is Not Null. On the second criteria line for SFM_2, type Is Not Null.
I believe that should list only the INTL_SHARE field for records where either SFM_1 or SFM_2 have a value.

Reply | Quote

I’ve tried that as well. The problem is: When SFM_1 is null it’s not displaying the value for SFM_2 and I don’t want that.

Reply | Quote

in sfm_1 place the not null on the first criteria line
on the sfm_2 put the not null in the second criteria line

Reply | Quote

Thank you JerryC, It seems to be working now, I’ll be in touch if it gives me any other problems.

Reply | Quote

Well then, I am confused … when you said “What I want to do is display INTL_SHARE ONLY “, I thought that meant INTL_SHARE was the ONLY field you wanted to display. I will try to be more helpful if you can explain what fields you want displayed and the condidtions that should cause them to be displayed ?

Reply | Quote

what I meant was I don’t want to display INTL_SHARE when SFM_1 or SFM_2 is null. But I do want to display it when either one of the isn’t null.

Thanks….

Reply | Quote

now i’m confused
you don’t want to see INTL_SHARE when SFM_1 is null and SFM_2 is not null
and you don’t want to see INTL_SHARE when SFM_2 is null and SFM_1 is not null
is this correct

Reply | Quote

No, What I want was to display the value for INTL_SHARE when either SFM_1 or SFM_2 has a value.
SORRY but I’m not good at explaining.

Reply | Quote

so is the query criteria working for you now

Reply | Quote

I really don’t know but it seems to be working with the data I’ve got now.

Reply | Quote