I have a table which contains three fields:
Current Former Never

I built an append query to load information into the Current field, there are 12,777 records, now I want to run two more queries. one to populate the Former field and one to populate the Never field.

When I run an append query to to pick up the Former records and load them into the table, rather than starting at the top of the table the information is inserted into line 12,778 in the Former field. Is there a way to have that information start the insertation to the Former field on line 1 ?

I have a table which contains three fields:
Current Former Never

I built an append query to load information into the Current field, there are 12,777 records, now I want to run two more queries. one to populate the Former field and one to populate the Never field.

When I run an append query to to pick up the Former records and load them into the table, rather than starting at the top of the table the information is inserted into line 12,778 in the Former field. Is there a way to have that information start the insertation to the Former field on line 1 ?

Is there a reason that you cannot use an Update Query? I think that An Update Query would do what you are looking for. Perhaps even starting over and running a query that updates all 3 at the same time?

I'll give that a try. Thanks

I'll give that a try. Thanks

If you still have problems, please post again and let us know what the table structures and the queries look like (Data should not be required).