How can I update or append from a query into an existing table.
The query is information that has been downloaded from an excel spreadsheet. Each month it will be refreshed with the previous month’s figures.
The table denotes specific room ID, room name and a field for each month.
If I use append, the first time for January it imports information perfectly. However, if I use append again for February it just adds additional records for the rooms and figures in february column.
I tried using an update query but have not been able to figure out how to make the query just enter the figures into the specific month’s column.
Any help would be greatly appreciated.
