Note to self: Do not use double quotes around field names

Note to self: If MS Access adds double quotes to field names in queries, do not use them! It won't complain about them (You'd wish it would), but it just won't work. So if you see something like: SELECT * FROM t_Mst_Tageserfassung WHERE ("TeMitarbeiter"=92) AND ("TeArbeitstag"=#12/24/2014#); Remove the quotes and it will start to work … Continue reading Note to self: Do not use double quotes around field names