 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008Pull field information only if it has information in it
I have a query that has a field that for some records it's blank while others it has information. Is there away to pull the records that have information in it so for example: 1 2 3 Ryan 4 5 6 Tom 7 Ryan If I wanted to pull the records that have names in it it'll only pull records 3, 6 and 7 Also, is there away to look for duplicate entries such as Ryan it'll pull records 3 and 7? Thanks Ryan In the query criteria, put Is Not Null. > I have a query that has a field that for some records it's blank while > others it has information. Is there away to pull the records that have [quoted text clipped - 15 lines] > > Ryan Didn't work, same number of results came up On Apr 16, 12:54 pm, Golfinray <Golfin...@discussions.microsoft.com> wrote: > In the query criteria, put Is Not Null. > [quoted text clipped - 18 lines] > > > Ryan put the Is Not Null statement in the name column, not the number column.....  SignatureNTC > Didn't work, same number of results came up > [quoted text clipped - 22 lines] > > > > > Ryan Use the duplicate query wizard to find records where a field has duplicate values. It will construct a query that looks something like SELECT FirstName FROM YourTable WHERE FirstName IN ( (SELECT FirstName FROM YourTable As Temp GROUP BY FirstName HAVING Count(*) > 1) '==================================================== John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County '==================================================== > put the Is Not Null statement in the name column, not the number column..... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.