Ms Access

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • John Pettitt
    #1

    Ms Access

    I have designed a Dbase,& I cant get all the Reports or some queries
    to Print Monthly Summaries in Monthly date order. The date is the
    first column & sorts alphabetically either Ascending or Descending
    order. Please Help.
    Tags: None
    • Rick Brandt
      #2
      Re: Ms Access

      "John Pettitt" <johnpettitt@co nnect.com.fj> wrote in message
      news:3049810c.0 405270447.58b80 0ca@posting.goo gle.com...[color=blue]
      > I have designed a Dbase,& I cant get all the Reports or some queries
      > to Print Monthly Summaries in Monthly date order. The date is the
      > first column & sorts alphabetically either Ascending or Descending
      > order. Please Help.[/color]

      When you use Format() to make a date look the way you want it is no longer
      a date value to Access, but just a string so it sorts accordingly. Include
      a non-formatted date in your query. You can sort on that while displaying
      the formatted one. If you are grouping on your formatted date then include
      another formatted date string with the same interval that will sort in date
      order even as a string.

      For example, the formatted date string "yyyy-mm" will sort alphabetically
      in the same order as if left as a true date.


      --
      I don't check the Email account attached
      to this message. Send instead to...
      RBrandt at Hunter dot com



        Comment

        • PC Datasheet
          #3
          Re: Ms Access

          John,

          Open your report in design view and click on the Grouping and Sorting button in
          the menu at the top of the screen. Set the report to sort on date in the dialog
          that appears. A report ignores any sorting set in a query that the report is
          based on.

          --
          PC Datasheet
          Your Resource For Help With Access, Excel And Word Applications
          resource@pcdata sheet.com
          https://www.pcdatasheet.com



          "John Pettitt" <johnpettitt@co nnect.com.fj> wrote in message
          news:3049810c.0 405270447.58b80 0ca@posting.goo gle.com...[color=blue]
          > I have designed a Dbase,& I cant get all the Reports or some queries
          > to Print Monthly Summaries in Monthly date order. The date is the
          > first column & sorts alphabetically either Ascending or Descending
          > order. Please Help.[/color]


            Comment

            Previous template Next
            Working...