I have a Union Query that is changing the format of a field from number to text. Each of the linked tables have the field as numbers; linked file table the Access Database is also in number format. However, when I combine the 5 tables using a Union Query, it converts the field to text and is causing mismatch errors in other queries. Is there a fix for this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Field Type Changing With Union Query
- Thread starter FBandData
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,244
- Office Version
- 365
- Platform
- Windows
Do you have any blank or null entries in any of these numeric fields in any of the tables?
Also, is the structure of all five tables exactly the same, the same field names and types in the same order?
Are you returning all fields from all tables, or just select ones?
Also, is the structure of all five tables exactly the same, the same field names and types in the same order?
Are you returning all fields from all tables, or just select ones?
Upvote
0
Similar threads
- Question
