check boxes

[coachjeffery]

I'm creating a report from a table that contains a number of check boxes.
When I create the report I want it to display the caption text rather than
the check box.

Student Date of test Tests taken this quarter
--------- ------------- --------------------------
john doe 1/1/2005 test 1
2/1/2005 test 2
3/1/2005 test 5...

I can query for yes or no on the check box but how do i get it to display
the text?

Thanks

 

[Duane Hookom]

Do you have a column for each test? In your sample below, are we viewing one
record or three?

 

[coachjeffery]

I only have 1 column. It is 3 seperate records.

Do you have a column for each test? In your sample below, are we viewing one
record or three?

 

[Duane Hookom]

I am totally lost as to what your table structure is. Can you provide some
sample records as well as field names?

 

[coachjeffery]

Field Name Data Type
-------------------------------------
Physician Name Text
Patient Name Text
PPM Explant Yes/No
Bi-V PPM Yes/No
ICD Explant Yes/No

Right now the report prints out:

Physician Name PPM -Explant Bi-V PPM ICD Explant
Patient Name Check Check No check - meaning
it shows the check box

What is want is:

Physician Name
Patient Name PPM - Explant - no check box, just the caption if box is
checked
Bi-V PPM
Next Patient Etc
Etc

Am i making any sense? I appreciate the help. It works in an option group
but option groups only let you check 1 box, i will have multiple boxes
checked per patient. Maybe 15 out of 25 will be checked.

 

[Duane Hookom]

You have "committed spreadsheet". In your first email, you had a date field.
Where is that field value coming from since you didn't mention it in your
most recent email?

Do you have a primary key field in this table?

Do you understand what normalization is and why your table is not
normalized?