Return customer name and between date values from query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gardy - 06 Jun 2006 21:01 GMT

I need to be able to retrieve two specific results from a query. One is
customer name and the other is a date that is related to the customer name .
data is pretty simple customer name, product id, serial number ,quantity date
sold,

Reply to this Message

Rick B - 06 Jun 2006 21:05 GMT

Just create a query and include the two fields you mention.

If you want to have the query ask you which customer, then put criteria
under the customer name field like...

Like "*" & [Enter Partial Customer Name] & "*"

If that does not answer your question, please give us more details. Your
question is a little bit vague.

Signature

Rick B

>I need to be able to retrieve two specific results from a query. One is
> customer name and the other is a date that is related to the customer name
> .
> data is pretty simple customer name, product id, serial number ,quantity
> date
> sold,

Reply to this Message