Pull field information only if it has information in it

[ryan.fitzpatrick3]

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

 

[Golfinray]

In the query criteria, put Is Not Null.

 

[ryan.fitzpatrick3]

Didn't work, same number of results came up

In the query criteria, put Is Not Null.

 

[NetworkTrade]

put the Is Not Null statement in the name column, not the number column.....

 

[John Spencer]

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
'====================================================