Report Question

[Neil Greenough]

I currently have a table which has a tick box in it. Now, I would like to
make a report which highlights all of the entries within this table which
have not been ticked. How do I go about this? I can use the wizard to show a
report which shows all entries ticked and unticked but I just want to create
a report which shows entries which have no tick.

Thanks

 

[Van T. Dinh]

Change the Report's RecordSource to a Query (or SQL String) and set the
criteria to select only those Records that the "CheckBox" Field is True.

 

[Neil Greenough]

Van,

I am only new to this. Can you talk me through this in more detail please? I
ain't got the foggiest where to start.

Thanks

 

[Van T. Dinh]

Open the Properties window of the Report in Design View. The second tab
should be the Data tab. Click the RecordSource row (1st row). The Build
button (with 3 dots) appears on the right of this row. Click the Build
button and the Query grid will appear where you can enter the criteria.

Most books cover this sort of things so if you are not familiar, suggest you
read the chapters on Queries and Reports.