Append Query

G

Guest

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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 append query to SQL is very slow 0
How to append running number 1
Data changes in append query 1
Preventing duplicate entries with an Append Query 3
How do I get Access to append the exact amount with decimals? 2
append query creating new records 2
Append query without duplicate rows 3
validation for append query help? 7

Top