Show records with criteria - query

[Lukael]

Hi,



let's say I have table with fields "ID","Names","Surname","Telephone".

Now I want to see only records from that table where "Telephone" is entered - so every "ID", "Name", "Surname" and "Telephone". How can I do that in query, and how ?


I know that is a simple question, but I'm kind of lost. I need this for quick reportings, and constructing new forms.


P.S: Note that telephone numbers are not same, so I can't just enter criteria of one number, I need all records that have telephone numbers filled.

thanks for help !

[ranman256]

Use the query wizard. it will build everything you need.
basics:
start a query, bring in a table to pull the data from
bring the fields you want to see onto the grid
run the query

[Lukael]

Yes, I understand. But If I bring all fields as in this example, query will show me all records, even those where "Telephone" is not entered.

I allready figured out : you have to put criteria "Is Not Null" in design view of query, under field you wish to "filter" records. I this example criteria goes under field "Telephone".

Thanks for help though !