Records Search

  • Thread starter Thread starter Devling5000
  • Start date Start date
D

Devling5000

I'm trying to compile a report and have it seperated by either regions or
sales person. What I'm looking to do is when the report is selected, to have
a combo box pop up and ask for either Region or Sales person. Any help with
this would be great.
 
Use a calculated field in your query --
SortField: IIF([Forms]![YourForm]![YourCombo] = "Region", [Region],
[Sales Person])

In the report design view click on Sorting and Grouping and select the
SortField.

You could also use a check box, then the IIF statement would look like this --
SortField: IIF([Forms]![YourForm]![YourCKBox] = -1, [Region], [Sales
Person])
 
Back
Top