How to run a report by selecting multiple criteria?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Neil Cho
    New Member
    • Nov 2010
    • 1

    #1

    How to run a report by selecting multiple criteria?

    Hello,

    I am VERY very new to MS Access and here is my question -

    I created a form, which has various drop down menus and I want the users to select different criteria and run a report. So it's basically like:

    If Combo15 = "North America" and Combo16 = "Canada"
    Then Runreport = "North America Sales"
    Else
    If Combo15 = "South America" and so on...

    Any help would be very very appreciated and thank you for your patience.
Working...