How can I include only the records...

  • Thread starter Thread starter Ted Clore
  • Start date Start date
T

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
 
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
 
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
 
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
 
Back
Top