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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Access Cross-table Query with multiple fields

  • 02-05-2017 4:17pm
    #1
    misstearheus
    Registered Users, Registered Users 2 Posts: 2,131 ✭✭✭


    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

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


    What type of database?


  • #3
    misstearheus
    Registered Users, Registered Users 2 Posts: 2,131 ✭✭✭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. :)


  • #4
    misstearheus
    Registered Users, Registered Users 2 Posts: 2,131 ✭✭✭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! :)


  • #5
    seamus
    Registered Users, Registered Users 2 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