General discussion
-
Topic
-
MS Access Append Query Problem
LockedI am attempting to add records from one table (table A) to table B.
Specifically, I’m trying to match the fields as follows:
Table A Table B
——- ——-
Amount to FY 2003 (IF another field for the
same record on Table “Grant
Year” equals 2003)Amount to FY 2002 (“” 2002), and so on.
————————————————-
What I’ve tried so far …Under the append query column (in design view) I included the following criteria: [Table A]![Grant Year]=2003
I repeated this for years 2002 – 2000.
When I look at the datasheet view it shows a zillion records to be appended when table A only had 45 records to begin with.
Any suggestions would be greatly appreciated. I’ve thought of modifying the field in Table B to directly correspond with table A’s fields, but I’m stubborn. I believe this should work, but how??
Thanks in adance!
Mike