Urgent question about appending data to a table / field but keeping the $ sign when converting to te

  • Thread starter Thread starter bomber
  • Start date Start date
B

bomber

Hi all.

I need to append info to a new table but I need the currency vales to remain
when appending to a text field.

I have Field1 (type Currency) in Table1

I have Field2 (type Text) in Table 2

I want to apend the currency values from Table1,Field1 to Table2. But when I
do it drops the "$" sign and the trailing zeroes.

This is very urgent as I need to send a file off tomorrow. Any ideas ?

cheers,

Adam
 
Adam,

Append to Table to from a calculated field in the query, like this...

FieldForAppend: Format([Field1],"\$#,###,00")
 
Hi all.

I need to append info to a new table but I need the currency vales to remain
when appending to a text field.

I have Field1 (type Currency) in Table1

I have Field2 (type Text) in Table 2

I want to apend the currency values from Table1,Field1 to Table2. But when I
do it drops the "$" sign and the trailing zeroes.

This is very urgent as I need to send a file off tomorrow. Any ideas ?
Click to expand...

Use a calculated field in your Query:

TextMoney: Format([currencyfield], "Currency")

and append this field rather than the table field itself.

This will convert the currency datatype field (actually a huge scaled
integer) to a text string, dollar signs and all.

Note that it is NOT NECESSARY to create a new table in order to export
a file - if there's not some other reason to do so, just export from
the select query (with the Format() function) directly!
 
Back
Top