Help with append query

[vbaInet]

So, I need to run my clear records query, ...

If that's what you're doing then yes.

..., then my current append query to the 500byte table ...

Correct

... and then create yet another table

No No No. Base another query on the table in red. A select query including ALL fields.

select query to make that field output properly?

Yeap, like explained above. Then you need the Format function (with link in the other thread) to get the formatting right.

The final export will come from the query.

 

[denileigh]

Thank you, I will try.

 

[vbaInet]

Just let us know how you get on or if you get stuck