Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Access Cross-table Query with multiple fields

Options
  • 02-05-2017 5:17pm
    #1
    misstearheus
    Registered Users Posts: 2,126 ✭✭✭


    Can anyone tell me how do I do a Cross-table Query with multiple fields?!? Been asked to put in 4 and 4 fields, but it seems the Wizard can only take a maximum of 3 and 3...

    Also what is a Detail Cross-table Query? Is Detail just one of the types ya select or criteria ya select in the Wizard process or what....


Comments

  • Options
    #2
    seamus
    Registered Users Posts: 68,317 ✭✭✭✭seamus


    What type of database?


  • Options
    #3
    misstearheus
    Registered Users Posts: 2,126 ✭✭✭misstearheus


    What do you mean by type? It would be a Relational one to the best of my knowledge if that's what you're asking. :)


  • Options
    #4
    misstearheus
    Registered Users Posts: 2,126 ✭✭✭misstearheus


    Think have sorted out the Cross-Table Query now.

    But I need to find out where I format Orientation to Left-To-Right for a Report. And Filter On Load to Yes... Help appreciated please! :)


  • Options
    #5
    seamus
    Registered Users Posts: 68,317 ✭✭✭✭seamus


    When I say what type I mean is it MSSQL, MySQL, PostGres, Access, etc?

    Edit: Re-reading your thread title I see it's MS Access...


Advertisement