Status = Closed

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

Guest

Hi - newbie access person here.

I have a report - works fine - the table it is accessing is showing all
records on my report. However, I don't want it showing any records where the
Status is equal to "Closed" - I want it to show everything, but Closed
records.

Can someone help me?

Thanks.

Ty
 
Base your report on a query based on your table. Set the criteria for Status
as Is Null.
 
Thank you.

However, I not quite sure how to create the query and how to make the query
work with the report.

Ty
 
Go to the database window and the query tab. Click New and select the query
wizard. The wizard will ask you what data you want; select your table from
the list. The wizard will give you a list of all the fields in your table,
click the All Fields button. Follow the instructions from there and the
wizard will create your query and open it. Click on the Design button and
type the following expression in the criteria for Status:
Not "Closed"
Close the query.

Go to the reports tab, click New and select the report wizard. Choose your
query from the list and then choose all the fields in your query. Follow the
instructins from there and you will get the report you want.,
 
Thank you very much for your help, however, I am not quite sure how to do
what you are telling me.

I am very new to access.

Ty
 
Look at my earlier response.


Ty said:
Thank you very much for your help, however, I am not quite sure how to do
what you are telling me.

I am very new to access.

Ty
Click to expand...
 
Back
Top