[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