Parse list of yes/no's

E

esarhaddon

I have a maint. DB that has a long list of yes/no to maint. functions in a
shop. I need to parse (extract) only the Yes or positive ticked items to a
report or form associated with it's particular work order #. Should be very
simple, but all of the answers to my inquiries fail to work.
 
T

tina

...associated with it's particular work order #.

well, that part loses me; but the simple answer is that if a field in the
table is a Yes/No data type, then you can write a query against that table,
and set criteria on the field to pull records with Yes values (or No values)
only. the criteria would be

True

or, instead you can use

-1

if you prefer.

hth
 
J

John W. Vinson

I have a maint. DB that has a long list of yes/no to maint. functions in a
shop. I need to parse (extract) only the Yes or positive ticked items to a
report or form associated with it's particular work order #. Should be very
simple, but all of the answers to my inquiries fail to work.
Click to expand...

If your table has many Yes/No fields... it's designed incorrectly. I presume
the fieldnames indicate questions or statuses applying to the item being
maintained? If so, consider normalizing your data:

Items
ItemID
<information about the item needing maintenance>

MaintenanceSteps
StepID <Primary Key>
StepDescription

Maintenance
ItemID <what's being maintained>
StepID <what maintenance is being done>
WorkorderNo <on what workorder is this being billed>
<maybe other fields such as maintenance date, outcome, etc.>

"Fields are expensive, records are cheap".
 
Top