Blank Parameters

Hi,
i would like to know how i can let a user have the option to enter in 1 or 2 parameters.
EG. select * from customer where ContractSigned = @.Parm1 and ContractReceived = @.Parm2
i would like the user to have the option to enter in either the signed date, received date or even both. I have tryed using the "Allow blank value" option with no luck
Thanks,
Sundeephttp://blogs.msdn.com/chrishays/archive/2004/07/27/199157.aspx
(If you don't have ValidValues queries, you can ignore that part)
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Sundeep" <Sundeep@.discussions.microsoft.com> wrote in message
news:6FB12C24-0AE9-4A65-B04F-C10C13FADF90@.microsoft.com...
> Hi,
> i would like to know how i can let a user have the option to enter in 1 or
2 parameters.
> EG. select * from customer where ContractSigned = @.Parm1 and
ContractReceived = @.Parm2
> i would like the user to have the option to enter in either the signed
date, received date or even both. I have tryed using the "Allow blank value"
option with no luck
> Thanks,
> Sundeep|||thanks i will try that
"Chris Hays [MSFT]" wrote:
> http://blogs.msdn.com/chrishays/archive/2004/07/27/199157.aspx
> (If you don't have ValidValues queries, you can ignore that part)
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Sundeep" <Sundeep@.discussions.microsoft.com> wrote in message
> news:6FB12C24-0AE9-4A65-B04F-C10C13FADF90@.microsoft.com...
> > Hi,
> > i would like to know how i can let a user have the option to enter in 1 or
> 2 parameters.
> >
> > EG. select * from customer where ContractSigned = @.Parm1 and
> ContractReceived = @.Parm2
> >
> > i would like the user to have the option to enter in either the signed
> date, received date or even both. I have tryed using the "Allow blank value"
> option with no luck
> >
> > Thanks,
> > Sundeep
>
>