Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Months query (Access 2000)

    How could i make my query follow the order of the months ? My query qryMargins, when filled in with data for the whole year, does not follow the order of the months,eg, january,february etc. Further ,it is the basis of the report and in the report the situation is the same ?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Months query (Access 2000)

    The database that you attached contains data for February only, so there is nothing to test.

    But I'd change the definition of the month field to

    Month: [InvoiceDate]-Day([InvoiceDate])+1

    in qryMarginMonthly. You can set the Format property the way you want.

    You will have to specify the sort order for the report in the Sorting and Grouping window.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Months query (Access 2000)

    Thank you , it is ok now, the months are ordered in their succession. I receive now the months as follows 01.1..2008, 01.2.2008 etc.But could i format them with the names? the formatting field in my query has disappeared and formatting the first field Expr1: [InvoiceDate]-Day([InvoiceDate])+1 is too complicated for me, i tried but failed

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Months query (Access 2000)

    You can specify the format in the Properties window, see the screenshots below (top: design view, bottom: datasheet view).
    Attached Images Attached Images
    • File Type: png x.png (16.1 KB, 0 views)

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Months query (Access 2000)

    Thank you once again so nice a solution ! yes, it works perfectly well !

Posting Permissions

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