Parameters for database connections

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?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,118,572
Messages
5,572,997
Members
412,494
Latest member
Letorc
Top