show only columns with data

[Guest]

I want to be able to allow teachers to select from a list of 20 possible
student needs. I propose have a table with 10 fields with a combo box for
selection and the fields used would vary from 1 used to all 10 fields. I wat
the report & Possibly the query to only show the used fields.

 

[Duane Hookom]

This type of question usually suggests an un-normalized table structure. I
could be very wrong.

You might want to look at the query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

This type of question usually suggests an un-normalized table structure. I
could be very wrong.

You might want to look at the query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

Any idea if chek boxes can be reported showing only the boxes selected

Thanks

 

[Duane Hookom]

What do you mean? Do you have a yes/no field that you only want shown on the
report if its value is True/Yes?
You should be able to use a regular text box using a font like wingdings
choosing the appropriate characters for the Format property.