Results 1 to 3 of 3
  1. #1
    MacAcc is offline Novice
    Windows 10 Access 2013
    Join Date
    Feb 2016
    Posts
    23

    Need help with a query

    Hi, I am not an expert, so please bear with me. I am trying to do a query and do not find the solution but I am pretty sure that there is a solution.
    So here is what I want to do: based on a table, I have the follwing query



    Periode (exemple: March2017)
    Client (exemple: Dummy)
    Amount (exemple USD 1300)

    Eventhough there are only 3 fields, there are hundreds of data (varios periods, lots of different clients and multiples amounts per client, period etc).

    Now, I want to make a new query in oder to get the follwing summary:

    I want to make a list which shows me for a certain period, let's say "March2017", a certain client (say Dummy), how much business he did (sum of Amounts).

    This should look like this:

    Client Jan2017 Feb2017 March2017 April2017 .................Dec2017

    Dummy 500 30000 45000 150 301
    Yummud 431 374 45 61 765
    Mmudy 307 156 37 21 17
    etc.

    How can I do that?

    Tks for the help.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a query, Q1, to pull the data in the date range you want.
    then use the query wizard and make a CROSSTAB query, using Q1.
    it will ask you to pick the row field, the column field, and the value field.

  3. #3
    MacAcc is offline Novice
    Windows 10 Access 2013
    Join Date
    Feb 2016
    Posts
    23
    Cool, tks, it Works.

Please reply to this thread with any new information or opinions.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums