Append Query

Q

QC Coug

I have a make table query and an append query table. The append query table
is not appending the amount, but it is appending everything else. The
formats of the data are different from the two sources so I'm sure the reason
why it is not appending the amounts is because they have different formats.

Is there a way to change the format in the append query to be consistent
with the make table query?
 
D

Duane Hookom

Formats are basically for display. You should be able to change your data by
using CDbl(), Val(), or some other function.
 
Top