If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Type Mismatch problem
Hi,
Management has recently asked us to separate cases deemed "aged" into different criteria depending on the weight of the case. This is hard because the ages involve two different calculations depending on what the case has been through (long story). Now I have to develop a query that will separate the aged cases into four different tiers with different criteria. I have a query with the following multiple criteria for AGE and WEIGHT: 120 In("1,0") and and 180 Like "2" and and 270 Like "3" and and 360 Like "4" And so on. It works except that I can't include the set of cases for which the age calculation is different. I made another query based on a union query so the two different calculations can be incorporated. The age number is a number type and the weight field type is a text type, just as it is in the other query. If I base another query on this union query, it will not let me enter the multiple criteria as above. It tells me there is a data type mismatch in the criteria. BUT ifI create a query from the union query with just one criteria, i.e. only the 120 Like "1" it comes out okay. Hope I've made myself clear. What gives? I hope I don't have to create queries for every single age designation of every single tier. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The database insert failed. Data type mismatch in criteria expression. | Wayne | General Discussion | 3 | January 30th, 2005 09:00 PM |
Why am I getting a data type mismatch in criteria message when I t | pleasehelp | Running & Setting Up Queries | 1 | January 12th, 2005 12:26 AM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Data Type Mismatch when Opening Recordset | Tom Rogers | Setting Up & Running Reports | 1 | July 29th, 2004 12:25 PM |
Data Type Mismatch | Derek Wittman | Running & Setting Up Queries | 5 | July 12th, 2004 06:24 PM |