My query has 2 fields. Field2 is a vblf demlimited list.
I would like to make a table where Field1 stays Field1 but the Field2 list becomes a separate field for each item.
Before playing around with a UDF I thought I'd ask here as there may be some existing "Access" way to do this ?
I would like to make a table where Field1 stays Field1 but the Field2 list becomes a separate field for each item.
Before playing around with a UDF I thought I'd ask here as there may be some existing "Access" way to do this ?