Union Queries - Record Formatting

  • Thread starter Thread starter MPgov
  • Start date Start date
M

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.
 
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.
 
Back
Top