Creating a sucessful query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI i wonder if anyone could possible help me, im trying to create a query
that shows a list of addresses, for e. i have company name, address, zip,
country etc. but i only want it to show me those records where i have data in
the company name field if itss empty i dont wan to see the record.
how do i do it? i know its something about null values but cant understand
where i put that in the query?

Hope someone can help me, i thank you all in advance for helping me with my
problem

Liz
 
john,
thank you so much i cant believe it was as esy as that ive been trying to do
this forthe past few hors and you have solved my problem
cheers

liz
 
It's always simple AFTER you know how.

lizannecole said:
john,
thank you so much i cant believe it was as esy as that ive been trying to
do
this forthe past few hors and you have solved my problem
cheers

liz
Click to expand...
 

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

Query to select individual records 4
#error - Blank 3
UnMatched Query 2
Making a Delete Qiuery from an unmatched Query 3
Parameter Query No Results - Needs to Auto Create Record 4
Access Determine what query to run based on a checkbox 0
Query showing unexpected results 5
Append Query is not working 1

Back
Top