Another Append Query ?

[Guest]

Hello All,

I have a table named "Applications" that I want to append data to from
another table named "Producer Percentage". Both tables have matching
"Percentage" field names and both tables have matching autonumber fields
named "ContactID"

When I append from "Producer Percentage" to "Applications", the data appends
at the last record instead of the first record.

How can I get the appended data to start at the first record instead of the
last record.

-sky

 

[Marshall Barton]

I have a table named "Applications" that I want to append data to from
another table named "Producer Percentage". Both tables have matching
"Percentage" field names and both tables have matching autonumber fields
named "ContactID"

When I append from "Producer Percentage" to "Applications", the data appends
at the last record instead of the first record.

How can I get the appended data to start at the first record instead of the
last record.

Tables don't have a "first" or "last" record, so your
querstion doesn't make sense.

How the records are displayed is controled by a query's
ORDER BY clause (except for reports where you use Sorting
and Grouping).

 

[Hyder]

Hello Sky

As Marshall has mentioned tables don't have an order really, while appending
your data all the ContactID field to the query and sort the ouput by
ContactID and this should resolve the issue.