How can I store multiple delimited value in MS Access DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to store multi check box value in a single field each value delimated
by comma in access DB. How can I get the value at user interface form
 
You don't

You create a related table, where there is one *record* (not one field) for
each of these items.

For an article introducing the idea of normalization, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209534

For an example explaining the basics of building this kind of structure,
see:
http://allenbrowne.com/casu-06.html

For a detailed example, showing how to match the anwers to quetions from a
survey, see:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'
 
Back
Top