Display report for nominated client

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mandyric@bigpond.net.au - 21 Mar 2006 08:23 GMT

G'day
Have made a query which I need to display the records in a report for a
nominated customer.
The fields I used are
CustomerID (Combo box), unitno, repairdate (paramater between start
date and end date)
All is fine when the dates are entered in the parameter, but it shows
all the customers for those dates on the report. I have played around
in the criteria for the customer but not really sure how it works with
2 parameters in the query.
How do I select the customer I nominate for the dates I enter.
Any help would be greatly appreciated
Peter

Reply to this Message

Kernow Girl - 21 Mar 2006 13:59 GMT

Hi Mandy - stick another criteria in the query on the Curstomer ID line.
[Enter Cust ID] or some such. You can have lots of criteria, just keep in
mind that if it is an 'AND' selection - like this customer ID and theses
dates then it needs to be on the same level. If it is an 'OR' like between
these dates or this customer ID then put one one the line below. Hope this
makes sense and helps. Yrs - Dika

> G'day
> Have made a query which I need to display the records in a report for a
[quoted text clipped - 9 lines]
> Any help would be greatly appreciated
> Peter

Reply to this Message