I have created a spreadsheet which has about 2600 entries. As a result of spelling errors on the data captures part I cannot get accurate information on my reports.
I created three new tables: Client Table: Depot Table: Driver Table, all tables are connected via relationships,On the Spread Sheet I crested three Drop down boxes drawing in information from the three new tables.
By inserting a drop down box my history ends, I need to update all the empty infomation, My spreadsheet has a field called Client (new table Fields are;KeyClient;and Client), Depot(new table KeyDepot;and Depot), Driver Table(Key Driver, Driver Surname,and Drive Firstname).
I have tried to update with Append Queries, update Queries, but nothing works.
Could you please tell me which Query to use, which field to append,and how to create the Query correctly as this is the first time I am using these types of Queries
Many Thanks
Dan Scott