converting check boxes to text

  • Thread starter Thread starter Mike Monville
  • Start date Start date
M

Mike Monville

This works great, but I think I have too many categories to make this
workable. I have 50 possible checkboxes, of which most members would only
have one to three, but some have as many as twelve. Also, how would I be
able to put those fields together for output on one line instead of
retaining their relative placement in the detail section? eg: a checked
acrylic box and one checked in watercolor results in all the empty fields in
between printing as white space.

I have the feeling that I should have put this info into a separate table.
Is it too late to do that without jumping thru too many hoops?

Mike
 
OK. I followed your advice and I normalized my tables and created a table
to join media and members and this works great in a query to pull out
desired info but I'm still having trouble with getting this data formatted
out in a report. Each member's media print out in a column which in some
cases can take up a whole page if the artist works in many mediums. I need
to be able to format the output so that the media prints out in a line(s)
rather than in one long column. Any easy way to do this?
 
Check out the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Another (codeless) solution is to place the media (join table) in a multiple
column subreport that displays across then down.

--
Duane Hookom
MS Access MVP
--

Mike Monville said:
OK. I followed your advice and I normalized my tables and created a table
to join media and members and this works great in a query to pull out
desired info but I'm still having trouble with getting this data formatted
out in a report. Each member's media print out in a column which in some
cases can take up a whole page if the artist works in many mediums. I
need
to be able to format the output so that the media prints out in a line(s)
rather than in one long column. Any easy way to do this?
 
Back
Top