Query null question

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
.

Relevant Pages

  • Re: Querying multiple Dates
    ... Do you really want to have to remember how many days "hath August"? ... Consider using the Monthfunction in a query. ... pull only that months volume? ... Ryan ...
    (microsoft.public.access.formscoding)
  • Re: Query null question
    ... To find all the records with duplicates, you can use the "Find Duplicates ... Query Wizard" or you can build it yourself: ... Ryan ... If I wanted to pull the records that have names in it it'll only pull ...
    (microsoft.public.access.formscoding)
  • Re: Query null question
    ... Criteria of Like "*" will not pull null records. ... GROUP BY Field1; ... Ryan ...
    (microsoft.public.access.formscoding)
  • Re: VMWare -> Physical Box
    ... Ryan D'Baisse wrote: ... > How feasible do you think it would be to pull the contents from a VMWare ... I'd try something like Norton Ghost, ...
    (Fedora)
  • RE: Query null question
    ... Criteria of Like "*" will not pull null records. ... GROUP BY Field1; ... KARL DEWEY ... Ryan ...
    (microsoft.public.access.formscoding)