Report or form creation from yes/no data field

L

lrxc

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?
 
K

KARL DEWEY

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?
 
K

KARL DEWEY

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top