Help writing SQL expression(s)

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

Guest

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!
 
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
 
Back
Top