Query Assistance

[access2010]

I normally do not have problems with Queries, buy this one does not work

Could you please tell me why it does not want to show us the records that are marked with "Watch"?

Thank you,
Nicole

 

[theDBguy]

Hi. Just a guess but try adding another Is Not Null below the first one in the first column.

 

[pbaldy]

What's the SQL of the query? What you've shown should work.

 

[Gasman]

Are you using table lookups?

 

[The_Doc_Man]

Show us the table structure and the SQL of the query. I'm with Gasman on this - we cannot be looking at the right thing to answer your question because that query design grid looks strictly legit.

 

[plog]

Could you please tell me why it does not want to show us the records that are marked with "Watch"?

1. There are no records in Investments01_tbl that have [PortfolioCode]='Watch".
1A. - You didn't use the right criteria--perhaps it should be "Watched" or "Wach"
1B. - You didn't apply the criteria to the right field. Maybe its not [PortfolioCode] where "Watch" is at.

2. There's other criteria you haven't shown us. Perhaps you have criteria on a field from another table in the query but don't think it was relevant to show.

3. You have another table in the query JOINed to Investments01_tbl that is acting as criteria. When you JOIN tables, the fields you JOIN them on act as filters--only records with matches in both table come through to the query results.

 

[access2010]

Hi. Just a guess but try adding another Is Not Null below the first one in the first column.

===
theDBguy
P.E.R.F.E.C.T, thank you

 

[access2010]

Thank you ALL for your suggestions.
theDBguy, suggestion corrected our problem

Nicole

 

[theDBguy]

===
theDBguy
P.E.R.F.E.C.T, thank you

Hi. Glad to hear that worked for you. Good luck with your project.

 

[namliam]

which tbh is nonsense, with or without the "is not null" in the first column doesnt make a difference in showing the "Watch" records.... something else has become different to make it work for you.

 

[Gasman]

I was confused by that as well.

 

[pbaldy]

I was confused by that as well.

Me three.

 

[The_Doc_Man]

<raises hand with 4 fingers extended>