Display report for nominated client

  • Thread starter Thread starter mandyric
  • Start date Start date
M

mandyric

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
 
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
 
Back
Top