If field is blank hide record in report or query

[Guest]

Hello all,

I have created a property management database of retail stores. Each store
is assigned a store number once it is approved by management. There are
records for numbered and un-numbered properties. The store number is NOT the
primary key, as some stores are designated by letters.

I want to create a report of all the stores addresses, but only want to
include those that have a "store number". Can someone help me with this?

Thanks.

 

[Marshall Barton]

I have created a property management database of retail stores. Each store
is assigned a store number once it is approved by management. There are
records for numbered and un-numbered properties. The store number is NOT the
primary key, as some stores are designated by letters.

I want to create a report of all the stores addresses, but only want to
include those that have a "store number". Can someone help me with this?

Create a query that retrieves the data you want in the
report. Under the store number field, use the criteria
Is Not Null

Once the query retrieves the proper se of records, set the
report's record source to the query and the rest should be
simple.