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

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.

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

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


"jsccorps" <jsccorps@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B21753C7-C743-479A-AB65-92545015DDDB@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Parameter query to get info on an individual customer or all custo
    ... Designing a form that will allow users to pull info on an individual customer ... Is there a way to set a query parameter criteria to do this? ...
    (microsoft.public.access.queries)
  • Re: Customer Due Dates
    ... the query to return "Overdues" will be specific to each ... I have a service entry form that allows me to enter the date in ... > which our company serviced an individual customer. ... > times that we serviced an individual customer, ...
    (microsoft.public.access.forms)
  • Customer Due Dates
    ... You can use the aggragate function MAX on the date then ... group by on the customer. ... >times that we serviced an individual customer, ... > The problem is that I need to get the query to only look ...
    (microsoft.public.access.forms)
  • Customer Due Dates
    ... display a list of all customers that are due for service. ... times that we serviced an individual customer, ... The problem is that I need to get the query to only look at the LastDate ...
    (microsoft.public.access.forms)