LraeSinned
New Member
- Joined
- Aug 12, 2008
- Messages
- 47
I have several worksheets using external data connections with parameters and am pretty comfortable working with this. I'm trying to do something now that I thought I had done before (2003?) but not having any luck. I'm probably close but not quite on target.
The dataset I want in my table has 27k records but if I filter this by a short list of values I could narrow the resultset to about 3000 records.
I already have parameters filtering on date and serial number, now want to filter on product code. I'm using MS Query, and want to have a filter set up as:
In ( [p1],[p2],[p3] )
If I enter this using an incorrect format I do get a syntax error, so MSQuery is evaluating the expression.
When I try this now I get an unhelpful " -10920 " and haven't found anything useful on the internet for this error message with MS Query.
Thoughts?
The dataset I want in my table has 27k records but if I filter this by a short list of values I could narrow the resultset to about 3000 records.
I already have parameters filtering on date and serial number, now want to filter on product code. I'm using MS Query, and want to have a filter set up as:
In ( [p1],[p2],[p3] )
If I enter this using an incorrect format I do get a syntax error, so MSQuery is evaluating the expression.
When I try this now I get an unhelpful " -10920 " and haven't found anything useful on the internet for this error message with MS Query.
Thoughts?
