How can I include only the records...

[Ted Clore]

....that are unchecked, in a check box, in a report. If the box is checked I don't want it on my report.

My database tracks jobs in the shop and when the job becomes inactive it has a check that closes the record. I want only the records that are unchecked to be on a repost because they are the open jobs in the shop.

Thank you,
Ted

 

[Lynn Trapp]

Base your report on a query and set the criteria for your Yes/No field to <> -1

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html



...that are unchecked, in a check box, in a report. If the box is checked I don't want it on my report.

My database tracks jobs in the shop and when the job becomes inactive it has a check that closes the record. I want only the records that are unchecked to be on a repost because they are the open jobs in the shop.

Thank you,
Ted

 

[Ted Clore]

Thank you Lynn, this worked perfectly.

Ted



Base your report on a query and set the criteria for your Yes/No field to <> -1

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html



...that are unchecked, in a check box, in a report. If the box is checked I don't want it on my report.

My database tracks jobs in the shop and when the job becomes inactive it has a check that closes the record. I want only the records that are unchecked to be on a repost because they are the open jobs in the shop.

Thank you,
Ted

 

[Lynn Trapp]

I'm glad I could be of assistance.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html



Thank you Lynn, this worked perfectly.

Ted



Base your report on a query and set the criteria for your Yes/No field to <> -1

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html



...that are unchecked, in a check box, in a report. If the box is checked I don't want it on my report.

My database tracks jobs in the shop and when the job becomes inactive it has a check that closes the record. I want only the records that are unchecked to be on a repost because they are the open jobs in the shop.

Thank you,
Ted