maketable query; creating blank fields

[Purdue2479]

Is there a way to enter blank fields into a maketable query without using Null, MfstAccsAmt: Null? I can't just use design view to change the field type because the table is deleted everytime the code is run. I have an update query that runs after the maketable query and populates the blank fields in the maketable. One of the fields the update query pulls from is a currency type. This is type is not carried over I am assuming because the field is set to Null. But if I do not set the field to Null it automatically creates an expression, Expr2: [MfstAccsAmtl]. Any suggestions?

 

[PookaTech]

To control datatypes and keep indexes around, it is better to use a delete and an append query instead of a make table. So instead of the make table firing a delete query fires deleting every record and then an append query fires appending all new records.

This allows you to totally control the table design and still have the same functionality. It does take two queries, but indexes are important for speed and it is important to be able to control datatypess so it is well worth it.

Pookatech

 

[Purdue2479]

Thanks, that worked.