custom reporting

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
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

Steve said:
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
Click to expand...



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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top