C
Chris Watson
I have written a query that selects values that fall between a range.
Although when I update the table "tbl_0100" (which is being used in
the query) the parentheses are taken out of the Between...And
statement and I get an Error 3075 in Access. I can no longer access
the query, so I must delete it and re-write the SQL. I was wondering
if there was a way to keep the parentheses in the query, because I
will have to update this table with new data periodically. It will be
unacceptable if I have to re-write the query every time I update the
data in the table. I have pasted the query below. I have seen a few
other posts with people having the same problem. Although there were
not any solutions posted. Thanks for all your help.
Query:
SELECT [qry_2400/2500].[WBS element]
FROM [qry_2400/2500] LEFT JOIN tbl_0100 ON ([qry_2400/2500].[WBS
element] Between [tbl_0100].[Field4] And [tbl_0100].[Field5])
WHERE ((([qry_2400/2500].[WBS element]) Not Like "76-090*" And
([qry_2400/2500].[WBS element]) Not Like "76-037*" And
([qry_2400/2500].[WBS element]) Not Like "76-038*" And
([qry_2400/2500].[WBS element]) Not Like "76R*" And
([qry_2400/2500].[WBS element]) Not Like "FY*") AND
((tbl_0100.Field10) Is Null))
ORDER BY [qry_2400/2500].[WBS element];
Although when I update the table "tbl_0100" (which is being used in
the query) the parentheses are taken out of the Between...And
statement and I get an Error 3075 in Access. I can no longer access
the query, so I must delete it and re-write the SQL. I was wondering
if there was a way to keep the parentheses in the query, because I
will have to update this table with new data periodically. It will be
unacceptable if I have to re-write the query every time I update the
data in the table. I have pasted the query below. I have seen a few
other posts with people having the same problem. Although there were
not any solutions posted. Thanks for all your help.
Query:
SELECT [qry_2400/2500].[WBS element]
FROM [qry_2400/2500] LEFT JOIN tbl_0100 ON ([qry_2400/2500].[WBS
element] Between [tbl_0100].[Field4] And [tbl_0100].[Field5])
WHERE ((([qry_2400/2500].[WBS element]) Not Like "76-090*" And
([qry_2400/2500].[WBS element]) Not Like "76-037*" And
([qry_2400/2500].[WBS element]) Not Like "76-038*" And
([qry_2400/2500].[WBS element]) Not Like "76R*" And
([qry_2400/2500].[WBS element]) Not Like "FY*") AND
((tbl_0100.Field10) Is Null))
ORDER BY [qry_2400/2500].[WBS element];