[AccessD] Sending parameters to a query

No but nothing stopping you having two parameters in the query, ie WHERE x =
[P1] OR x = [P2]

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Jeff Barrows
> Sent: 15 April 2005 23:56
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Sending parameters to a query
> 
> 
> OK, I solved the first issue (see below).  The problem was 
> that I was sending the * with double quotes, AND appending 
> leading and following "s.
> 
> New Issue, is it possible to send TWO criteria in a Parameter?
> 
> Example:
> 
> Parameter01 ("ValueA" Or "ValueB")
> 
> 
> 
>  
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Brett Barabash
> Sent: Thursday, April 14, 2005 1:06 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Sending parameters to a query
> 
> Jeff,
> 
> If you use a Like operator instead of an equals sign in your 
> WHERE clause, you can pass in an asterisk to select all. For example:
> 
> SELECT Employee.FirstName, Employee.LastName
> FROM Employee
> WHERE Employee.LastName Like [MyNameParameter];
> 
> To get a specific employee, you would pass in "Smith", 
> "Jones", etc.  If you pass "*" as the parameter instead, it 
> will return all records.
> 
> 
> -----Original Message-----
> From: Jeff Barrows [mailto:Jeff at outbaktech.com]
> Sent: Thursday, April 14, 2005 10:31 AM
> To: AccessD
> Subject: [AccessD] Sending parameters to a query
> 
> 
> Hello Group!!!
>  
> I am at a client site and I am having a brain dead moment here.
>  
> I have a form where the user selects the parameters for a 
> report (query).  I send the Parameter to the query to 
> populate the report. Here is the problem, what do I send as 
> the parameter if the user wants to select 'ALL' of the 
> possible values for the Parameter.  I know that I have seen 
> or done this before, but I can not think of how I did this.
>  
> Please Help!!
>  
> TIA
>  
> Jeff Barrows
> MCP, MCAD, MCSD
>  
> Outbak Technologies, LLC
> Racine, WI
> jeff at outbaktech.com
> 
> --------------------------------------------------------------
> ----------
> --------------------------------------------
> The information in this email may contain confidential 
> information that 
> is legally privileged. The information is only for the use of 
> the intended 
> recipient(s) named above. If you are not the intended 
> recipient(s), you 
> are hereby notified that any disclosure, copying, 
> distribution, or the taking 
> of any action in regard to the content of this email is 
> strictly prohibited.  If 
> transmission is incorrect, unclear, or incomplete, please 
> notify the sender 
> immediately. The authorized recipient(s) of this information 
> is/are prohibited 
> from disclosing this information to any other party and 
> is/are required to 
> destroy the information after its stated need has been fulfilled.
> 
> Any views expressed in this message are those of the 
> individual sender, except where 
> ,
> states them to be the views of Tappe Construction Co.
> 
> This footer also confirms that this email message has been 
> scanned for the presence of computer viruses.Scanning of this 
> message and addition of this footer is performed by 
> SurfControl E-mail Filter software in conjunction with virus 
> detection software.
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>