Append and Switch?
Posted on 2014-12-07
I have an Append query. I am appending from Excel.
The table (tblReport) I am Appending to has a field [Receivor] with a property of Number, combo box and a row source query of: SELECT tblReceivor.ID, tblReceivor.Receivor FROM tblReceivor ORDER BY tblReceivor.Receivor;
tblReceivor has 26 records.
How to Append this text data from Excel [Receivor] to this field tblReport.[Receivor] with a Number ppty? I know a Switch statement would work however I think SWITCH is more practical for <5 options or so and is not very practical for 26 options to account for. I imagine there is an easier way.