custom reporting

[Steve]

I have created a report from a database that I have created. but I only want
to populate the report with incomplete jobs.

the columns I have area

Shipping #, Invoice # Client Name, Confirmation #, Brief Machine desc, job
complete.


Job complete is a yes/no tick box.

I would like to have the report show only the records that have no tick in
this box.

Can any one help please.

I have Office 2003.

thank you

Steve

 

[fredg]

I have created a report from a database that I have created. but I only want
to populate the report with incomplete jobs.

the columns I have area

Shipping #, Invoice # Client Name, Confirmation #, Brief Machine desc, job
complete.

Job complete is a yes/no tick box.

I would like to have the report show only the records that have no tick in
this box.

Can any one help please.

I have Office 2003.

thank you

Steve

Create a query that shows all of the records.
Then as criteria on the [JobCompleted] column, write
0

Only un-checked records will be retrurned.
Use the query as the report's record source.

 

[Larry Linson]

Base the Report on a Query, and in the Query, put a Criteria value of
"False" for the JobComplete Field.

Larry Linson
Microsoft Office Access MVP

I have created a report from a database that I have created. but I only
want
to populate the report with incomplete jobs.

the columns I have area

Shipping #, Invoice # Client Name, Confirmation #, Brief Machine desc, job
complete.


Job complete is a yes/no tick box.

I would like to have the report show only the records that have no tick in
this box.

Can any one help please.

I have Office 2003.

thank you

Steve

__________ Information from ESET Smart Security, version of virus
signature database 4020 (20090420) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4020 (20090420) __________

The message was checked by ESET Smart Security.

http://www.eset.com