Parameter query to get info on an individual customer or all custo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jsccorps - 21 May 2005 01:10 GMT

Designing a form that will allow users to pull info on an individual customer
or all customers. For example, query parameter [Customer ID] for an
individual customer, and [some wild card character] for all customers.

Sample form format:

Enter Customer ID: ______ (could use a wildcard char to pull info on all
customers)

Is there a way to set a query parameter criteria to do this?

Reply to this Message

David Lloyd - 22 May 2005 01:12 GMT

One approach you may want to look at is to use the "LIKE" SQL syntax.

For example:

SELECT *
FROM Customers
WHERE CustomerID LIKE [Customer ID]

Using the * wildcard parameter for [Customer ID] would return all records.

Signature

David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.

Designing a form that will allow users to pull info on an individual
customer
or all customers. For example, query parameter [Customer ID] for an
individual customer, and [some wild card character] for all customers.

Sample form format:

Enter Customer ID: ______ (could use a wildcard char to pull info on all
customers)

Is there a way to set a query parameter criteria to do this?

Reply to this Message