Access 2007 - Build Event on Report

[TANYA COHEN]

Hello All

I think I have a simple question but I cannot seem to do it.

I have a table which has a field with a row source "Open";"Closed"

I have created a report but I only want it to show "Open" records.

I have tried to edit the layout but that does not seem to work. So I
presume when I am in the design view, that I need to create an expression on
that particular field. I have no idea what code to use.

I right click on the detail bar and try build an expression which says
[Status] = "Open". I have also tried without the quote marks.

I must be doing something wrong because the report still shows Closed and
Open records.

Please could someone help

 

[Irene]

u can try like this:

SELECT * FROM your TABLE NAME WHERE status="open";

u put it at the record source of your report. hope this is the answer you
want.