Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Append Query again ?????

Status
Not open for further replies.

andrep

Technical User
Feb 27, 2002
40
0
0
CA
My append query shows the correct results !

However the table i am appending to receives all the information except the currency values which a switched
back to $0.00.

Yet when i look at the query the amounts are not $0.00.

Are there any special considerations to take into account
when appending currency values ?
 
hi
are you sure the target field is the type currency? if it is, maybe you can try (in the source) to force the format (format([fieldname],"Currency")

Mal'chik
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top