Union Queries - Record Formatting

[MPgov]

I used a Union query for many similar spreadsheets for different clients.
However, it seems that the Union query has limitations of 50 Union queries.
So, I created four different Union queries and then created a new (Great)
Union query to merge all four. This actually worked.

But my question, many of the original spreadsheets had a Record that was set
to currency. When I first created the first Union, some of the Records
changed to integer (not currency). I also noticed even more changes to this
Record on the (Greate) Union query. Any advice is much appreciated.

 

[Allen Browne]

Simplest solution would be to create a table with the field types you want.

Then execute a series Append query statement to add each set of data to the
table, following a Delete statement to clear out any data from last time if
needed.