Multiple Dates in one field

[RBPM]

Good afternoon to the forum,

My predicament is that I am converting an Excel spreadsheet into Access. In one of the columns (fields) there are mutiple date values (10/01/2004 10/15/2004 10/30/2004)in one column.

Any way to set up a multivalue field in access?

Access converts the column into a text format but i need to have it as dates rather than text.

Any help greatly appreciated.

Thanks

 

[PHV]

Any way to set up a multivalue field in access?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886