Append query

[ChristopherL]

Hi!
Aplogize for making two posts like this.


But I seem to be having another issue I am stuck on.
I want to make an append query, where I append values to a new column.

Example

ID MyValue
1 0.2
2 0.3

APPEND CounterpartyValue
ID MyValue CounterpartyValue
1 0.2 0.3
2 0.3 0.4

How do I do this?

Many thanks
/ C

[rpeare]

so your table has the fields

ID
MyValue
CounterPartyValue

how are you determining the value of CounterPartyValue, is it always .1 higher than MyValue? is it from data entry? how is it calculated?