Field justification in update query

I need to combine records (vendor accounts) in a table. I
want to add the values associated with each record and
post the cumulative total to the single combined record.

For example:
I have 3 records with different dollar totals associated
with each record. I want to combine all 3 into a single
record and the dollar total needs to be the cumulative
total of all 3.

What I have:
Record Total
1000 500.00
1050 250.00
1100 300.00

What I want:
1000 1050.00

I can generate the proper totals, but when I write the
cumulative total back to the the final single record, I
need to right-justify the value. I am writing to a 12-
charater field including the decimal poisition. I also
need for the cumulative total to always use 2 decimal
places.

Thanks for any help as I am still learning.

ted

Where are you trying to right-justify? On a form or report? Set the field's
Align property to Right.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ted" wrote in message
...
I need to combine records (vendor accounts) in a table. I
want to add the values associated with each record and
post the cumulative total to the single combined record.

For example:
I have 3 records with different dollar totals associated
with each record. I want to combine all 3 into a single
record and the dollar total needs to be the cumulative
total of all 3.

What I have:
Record Total
1000 500.00
1050 250.00
1100 300.00

What I want:
1000 1050.00

I can generate the proper totals, but when I write the
cumulative total back to the the final single record, I
need to right-justify the value. I am writing to a 12-
charater field including the decimal poisition. I also
need for the cumulative total to always use 2 decimal
places.

Thanks for any help as I am still learning.

ted