Sounds like you are confusing fields and records, more properly known as columns and rows. You use DML queries to delete rows, you use DDL instructions to drop columns. Here, you are using DML to delete rows. As such, you don't specify column names.
FROM [(SE)_tbl_Exchange_Rates] INNER JOIN [Holding Table] ON ([(SE)_tbl_Exchange_Rates].Month = [Holding Table].Month) AND ([(SE)_tbl_Exchange_Rates].CODE = [Holding Table].CODE);
You are right - I confused records and fields in my heading. I obviously mean records i.e. rows of data I want to delete and not columns. I have tried the code you supplied previously but I get the following error message:Could not delete from specified table
The table is not open and it is not read only.....
WHERE EXISTS (SELECT NULL FROM [Holding Table] WHERE [(SE)_tbl_Exchange_Rates].[Month] = [Holding Table].[Month] AND [(SE)_tbl_Exchange_Rates].[code ] = [Holding Table].[code ])
NOTE - I have had to add a space in [table name].[code ] as code is a reserved word here.
Probably a reserved word in Access too. Month certainly is...