Can you share the SQL view? Have you declared the data type of your criteria?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sun, 30 Nov 2014 23:24:33 +0000
Subject: [MS_AccessPros] MAXIMUM NUMBER OF CRITERIA IN MSACCESS QUERY
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sun, 30 Nov 2014 23:24:33 +0000
Subject: [MS_AccessPros] MAXIMUM NUMBER OF CRITERIA IN MSACCESS QUERY
Please can someone assist. I was running a query with many criteria (very well in excess of 60) and the system came back with a message that 'Query is too complex' I thought I could go as far as 255 columns .
Thanks.
Ade.
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar