D
DawnTreader
Hello All
i have 2 fields in a table. one is the id field the other is one where i
have cut and pasted from an excel sheet.
in the second field i have data that looks like this: 18106-1,-2
how do i change it to 2 seperate records that looks like this: 18106-1
18106-2
should i be using an append or update query or code? and if a query will do
this what does the sql look like?
thanks for any and all help
i have 2 fields in a table. one is the id field the other is one where i
have cut and pasted from an excel sheet.
in the second field i have data that looks like this: 18106-1,-2
how do i change it to 2 seperate records that looks like this: 18106-1
18106-2
should i be using an append or update query or code? and if a query will do
this what does the sql look like?
thanks for any and all help