In excel it is possible to enter information into a cell separated by commas and then have another column break it down into multiple cells in the column. In other words if this is in a cell [cm,ok,lp,ij] excel separates the information and creates the following.
[cm]
[ok]
[lp]
[ij]
In access is this possible? Enter all the information in one field and then have access separate it with a query or something or would I have to create a separate field for each entry? I did it like this in excel to save space as I have 15 possible codes to enter so that would be one field or 15. any Guidance on this would be appreciated.