massa said:
I have multiple fields in a table. I need to move duplicate records(they
have
same id number and dollar amount) into the update field 3/31/2008. Hoe do
I
accomplish this? Thanks.
doument id usd usd as of 3/31
222 1.10
222 1.10
Create a work table that is the result of a Totals query that lists the
document ids which have more than one record.
Then, loop through that work table.
1) read the document id
2) create a query set of all the records with that document id
3) loop through this second queryset
4) build the values you want to post in the "usd as of 3/31" field. I'm
not sure what you want in this field, but it might take some string
manipulation. You should show us what you want the update field to look
like after you've done your processing.
5) post the value you built in step 4 to the update field(s). You didn't
say if you want all the records to have the same value in the update field.