Re: John

From: PC Data*** (nospam_at_nospam.spam)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 17:55:11 GMT

Use a form where the user can enter Parameter B. Your query then looks like:

Select * From Table1 Where A=
Forms!MyForm!NameOfControlWhereParameterBWasEntered 

--
                                        PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"John" <John@discussions.microsoft.com> wrote in message
news:FE036913-A3E7-44AE-AD4A-2930E6D85574@microsoft.com...
> I have query  (saved as Qu1)
>
> Select * From Table1 Where A= Parameter B
>
> How can pass the parameter into query?
>
> Or how can I build a store procedrue in MS Access 2002. Please show me a
> simple sample.
>
> Thanks
>