This is my last attempt.
I challenge any of you to the following:
Build two table with two fields each. This should take 3 minutes.
Table One: FieldOne FieledTwo
Table Two: FieldOne FieldTwo
Table One has the following data:
FieldOne FieldTwo is empty
CHECKCARD 0124 APL*ITUNES 23458 2223
CHECKCARD 0222 APL*ITUNES 33233 3322
COOK OUT FREEDOM DRPS
CHECKCARD 0111 PAT OBRIANS BAR NOLA
Table Two has the following data:
APL*ITUNES Apple Itunes
COOK OUT Cook Out
PAT OBRIANS Pat O'Brians
Ok, now link TableOne FieldOne with TableTwo FieldOne and replace all of TableOne FieldTwo with data from TableTwo FieldTwo.
Simple with SQL in Access. Can anyone write a script to do this?
I want to thank all who have helped me get close, but not over the edge.
If this can not be done I will be staying with Access.