Help writing SQL expression(s)

K

Katie K

I need to create a query and/or report that will only display specific pieces
of information. In column/field 'A' I only want to display the records that
have that particular field populated...I also have column/field 'B' and i
only want that information to display along with the inforamtion from column
'A'. How do I write a SQL expression to filter out that information?

Thank you, I'm going crazy!
 
R

Ronald W. Roberts

Katie said:
I need to create a query and/or report that will only display specific pieces
of information. In column/field 'A' I only want to display the records that
have that particular field populated...I also have column/field 'B' and i
only want that information to display along with the inforamtion from column
'A'. How do I write a SQL expression to filter out that information?

Thank you, I'm going crazy!
Click to expand...

A fast way to create SQL statements is to create a query using the table
and fields required.
Then in the criteria row of the query enter "Is Not Null" or what ever
is needed.
Test your query by going into datasheet view. If it works, go into
SQL view and copy
the SQL code that was created.

Ron
 
Top