Results 1 to 4 of 4
  1. #1
    HotelierDream is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2020
    Posts
    31

    Sort Data and make single row based on field value


    Hello all,

    I have the table below (see screenshot) and I need a way to sort the transactions by payment type and combine it on one table as a single record.

    Basically I want to take the data and put it on a table with the following fields:

    Click image for larger version. 

Name:	Capture.PNG 
Views:	19 
Size:	15.3 KB 
ID:	43769

    date = date
    Amex = American Express Total
    Cash = Cash total
    Visa = Visa Total
    Mastercard = Mastercard

    How would I do this? I know its a query but im at a loss on the way.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use the query wizard and make a CROSSTAB query.
    it will ask for what field to use as:
    row header
    column header
    value (intersection)

  3. #3
    HotelierDream is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2020
    Posts
    31
    Quote Originally Posted by ranman256 View Post
    use the query wizard and make a CROSSTAB query.
    it will ask for what field to use as:
    row header
    column header
    value (intersection)
    That worked to get it into Query format but how would I then append to a table? I eventually would need to export data to excel and it would be easier to manage with a table.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make an append query, add in the Crosstab query as the source.

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

Similar Threads

  1. Replies: 14
    Last Post: 05-14-2020, 12:24 PM
  2. Replies: 1
    Last Post: 12-04-2016, 05:43 PM
  3. ASC or DESC Sort Based On Another Field
    By KikoMatsing in forum Access
    Replies: 1
    Last Post: 08-12-2014, 10:34 AM
  4. Replies: 2
    Last Post: 07-07-2014, 09:19 AM
  5. Replies: 7
    Last Post: 03-14-2012, 10:56 AM

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