Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: Report date field and sort it by year/Month/Week (Oldest to Newest)

    Hello,

    I'm trying to create a report based on a query

    I'm looking for a formula that will take my Report date field and sort it by year (Oldest to Newest)
    I would also like to put this date in a Colum header for each row year (Oldest to Newest)

    I would like to continue breaking down the query/Report to take Report date field and sort it by month (Oldest to Newest)
    again I would also like to put this date in a Colum header for each row year (Oldest to Newest)

    Is there a formula that will do this in the query and if need be the report


    Please see the attached report for an example

    I'm also looking for a way I can take this report sort (Oldest to Newest) and on a form allow me to enter an amount (example) 500,000 from older Report Amount and export all those account that add up to 500,000

    Thank TCB
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Just sort on the date field in the report GROUP/SORT bar

Posting Permissions

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