LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 108
Default MS Query - 2 Parameters

I've got an external data query that gets the value from a cell (vendor
number) and refreshes the spreadsheet. I'd really like another parameter
that references a second cell but I haven't gotten this to work yet. I need
the second parameter to be process level 'PSBP' or 'ZERO'. I'm adding this
after the fact; the process level should really be the first parameter with
the vendor number second. If you set the process level parameter to refresh
automatically and then go after the specified vendor number, how do you keep
the process level? When you key a different vendor number the second refresh
would ignore the process level wouldn't it?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Parameters wthin Query of External Data Sean Excel Worksheet Functions 1 November 16th 06 09:50 PM
Multiple parameters in MS Query Ken Excel Discussion (Misc queries) 1 August 19th 06 01:48 PM
Cannot get Wildcards in Parameters to work in MS Query/Excel2003 Jan K Excel Discussion (Misc queries) 3 February 17th 06 06:00 PM
Query Parameters Texas_Toast Excel Discussion (Misc queries) 0 January 11th 06 03:14 PM
Help : Using Parameters with External Date Query Bdavis Excel Discussion (Misc queries) 0 March 31st 05 05:03 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"