Query Assistance (1 Viewer)

access2010

Registered User.
Local time
Today, 13:42
Joined
Dec 26, 2009
Messages
1,019
I normally do not have problems with Queries, buy this one does not work
1596559442163.png

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

Thank you,
Nicole
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:42
Joined
Oct 29, 2018
Messages
21,358
Hi. Just a guess but try adding another Is Not Null below the first one in the first column.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:42
Joined
Aug 30, 2003
Messages
36,118
What's the SQL of the query? What you've shown should work.
 

Gasman

Enthusiastic Amateur
Local time
Today, 20:42
Joined
Sep 21, 2011
Messages
14,047
Are you using table lookups?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 15:42
Joined
Feb 28, 2001
Messages
27,001
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

Banishment Pending
Local time
Today, 15:42
Joined
May 11, 2011
Messages
11,611
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.
 

namliam

The Mailman - AWF VIP
Local time
Today, 21:42
Joined
Aug 11, 2003
Messages
11,696
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

Enthusiastic Amateur
Local time
Today, 20:42
Joined
Sep 21, 2011
Messages
14,047
I was confused by that as well. :D
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 15:42
Joined
Feb 28, 2001
Messages
27,001
<raises hand with 4 fingers extended>
 

Users who are viewing this thread

Top Bottom