Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014
    Posts
    3

    Unanswered: Need help to make a query

    Hello. I work in a small organization and manage our access database which I've created with my basic db knowledge.

    Now I have to make my anual reports and this year they asked one more report which I'm having difficulty to complete.

    My db has several fields and now I need to make a query using two fields which are Nationality and gender and create a table like this:

    Click image for larger version. 

Name:	Snap 2017-01-05 at 16.24.56.jpg 
Views:	7 
Size:	16.0 KB 
ID:	17237


    How can I build this query in access?


    Thank you.

  2. #2
    Join Date
    Dec 2016
    Posts
    22

    CrossTab query

    This doesn't tell you how to do it (mainly because I have not experimented with them) but I think it is a crosstab query you want to do.

    Have you tried it? What data do you have and I can try it on my end and see what happens. (I don't have any crosstab data right to play with).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •