Report or form creation from yes/no data field

[Guest]

I have a form (pending service) that has a total of 50 yes/no data fields. I
want to create a report or a datasheet that only displays the yes answer
along with the corrisponding field. For example, the "oil change" and the
"Wiper replace" yes/no box are both checked to "yes", I want a report to
print out, or a form to show only "oil change" and Wiper Replace" under the
vehicle number. Is that possible with my setup?

 

[Guest]

I have a form (pending service) that has a total of 50 yes/no data fields.
The big question is how are the data stored in your table? You are using a
table are you not?

 

[Guest]

Yes, all 50 yes/no questions are stored in one table.

 

[Guest]

I recommend that your database structure be something like this.
Vehicle ---
VehID - autonumber - primary key
Make
Model
etc

MaintWork ---
MaintID - autonumber - primary key
SvcDate - DateTime
Ready - DateTime
SvcMgr - Number - integer - from employee table
Rmks - memo

Service ---
SvcID - autonumber - primary key
SvcAct - Number - integer - from Service Action table
Start - DateTime
End - DateTime
Rmks - memo

ServiceParts ---
SvcPart - autonumber - primary key
SvcID - Number - integer - from Service table
Part - text
QTY - number - integer