[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.