Excluding Records from Reports

J

JBren

Joined
Oct 10, 2012
Messages
16
Reaction score
0
I've looked around Google and here and I've seen similar posts but nothing that has really helped me yet. What I have is a contacts list with the basic fields (name, address, phone number, ect). I would like to generate a report that shows the contact's name and phone number and leave out contacts that don't have a phone number. This is my first database build so please leave step by step instructions! Thanks!
 
J

JBren

Joined
Oct 10, 2012
Messages
16
Reaction score
0
This is what I did:

Created a query that gathered the information I wanted.
Added <>" " to the Criteria of "PhoneNumber" to leave out blanks.
Generated report using query!

Worked great!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reporting Out Two Names w/Phone # from the Same Table 1
One Command button for different reports 2
How keep blank non-existent records from appearing in sub-report? 1
Shrink "repeated" records, need help. 1
Multiple Records into Single Record 3
Updating field from a combo box 2
Field from another table 1
showing fields from another table 1

Top