access sorting

M

massa

I have three fields:
1/31/2008 3/31/2008 $amount as of 3/31/2008

Fields one and two contain duplicate data, they are clien id numbers. I need
to merge the two field into one. Field 3 is the amount due as of 3 /31. I
need to link the $$ amount to Field 2.
How would I go about doing this?
Thanks.
 
Top