Parameter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with fields such as sales reps, supervisors and managers and
their sales figures. The query has to be able to give sales figures for
individual sales reps, supervisors, managers. I am using parameter query for
this. I have built a parameter for each field: sales rep, supervisor and
manager in their respective location. Now when I run the query, it asks to
input values for all 3 parameters as expected. But when a sales rep's name is
entered, a supervisor's name should not really be required. How can I modify
my query to be able to get results just by passing to one parameter
 
Use Or instead of AND in the query
Select * from mYTable Where myField1 = [Enter Value1] or MyField2 = [Enter
Value2]
 
Back
Top