Hi I have a table with custnum, TrDate, Notefield, Vernumber. There may be more that 1 row per day but the Vernumber is an autonumber field and should have a bigger number for the second note for the day.
I want to Insert the rows into a new Table using a Varchar field. I want to have a PK on custnum and the date in the new table. This is easy but I want to add the second row for the day to the bottom of the Varchar field for the days with 2 rows. This is where my brain starts to twist. I can think of clunky ways of doing this but I am sure there are better ways than what I an thinking of? Is there a simple way to do this or do I just clunk along? Thanks Marc
