X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Get Data Type, Access 2016    
post Aug 15 2019, 10:51 AM

Posts: 1,117
Joined: 16-June 05

I am trying to run a Union query but keep getting a data type mismatch error message
The two queries making up the union query run fine

How can I determine the data type of each field in the queries?
If I know this, then I will know which fields are causing the error

Thanks in advance
Go to the top of the page
post Aug 15 2019, 10:54 AM

UA Moderator
Posts: 78,596
Joined: 19-June 07
From: SunnySandyEggo

Hi Tim. The simplest way is to open the table source in design view and check the data type of the field referred to in the query. Otherwise, are you looking for some code to do it?

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    3rd August 2020 - 04:12 PM