Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default MS Query parameter

Does MS query accept to pass parameter?

If yes, how can I pass them?

Your infromation is great appreciated,
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default MS Query parameter

yes it does.
Right click in the query data, click edit query.
when the query wizard comes up, click to the last screen and check...
view data or edit query in microsoft query. click finish.
when the MSQ dialog comes up, on the menu bar click criteriaadd criteria.
you can enter your parameters here.

Regards
FSt1

"Souris" wrote:

Does MS query accept to pass parameter?

If yes, how can I pass them?

Your infromation is great appreciated,

Reply
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
Parameter query in MS Query from Excel Jimbo Excel Discussion (Misc queries) 1 September 9th 09 04:27 PM
Convert hard coded query criteria to Parameter Query Melanie[_2_] Excel Discussion (Misc queries) 0 July 15th 08 09:59 PM
How to choose if I use a parameter or not in a parameter query Arnaud Excel Discussion (Misc queries) 0 March 8th 07 01:19 PM
Parameter query mtate Excel Programming 2 April 20th 05 09:02 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 01:34 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"