Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

count by month

Discussion in 'Information Technology' started by smason, Jul 28, 2006.

Tags:
  1. smason

    smason
    Expand Collapse
    Guest

    Hello i have a query which has the following

    placement id date placed
    1 01/01/2006
    2 02/01/2006
    I have the format sett to mmmm-yy so it reads january 06 not 01/01/2006

    when i try to count how many entries are for january i get the following
    results
    month count
    january 1
    january 1

    instead of
    january 2

    any ideas please
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---The Accountant Theatre, Movies & Cinema Oct 21, 2016
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    wolf count Blogs Oct 17, 2015
    recount Blogs Oct 17, 2015
    Events Banda Singh Bahadur's Martyrdom - An Eyewitness Account History of Sikhism Mar 26, 2015

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    In the Field row of your query, enter:
    Format([date placed], "yyyymm")

    That gives you a 6-digit number (4 x year + 2 x month), which will sort
    correctly.

    Alternatively, use 2 fields (i.e. 2 columns of the Field row):
    TheYear: Year([date placed])
    and
    TheMonth: Month([date placed])

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "smason" <smason@discussions.microsoft.com> wrote in message
    news:D8D7966A-F161-480E-B032-93711A064AEA@microsoft.com...
    > Hello i have a query which has the following
    >
    > placement id date placed
    > 1 01/01/2006
    > 2 02/01/2006
    > I have the format sett to mmmm-yy so it reads january 06 not 01/01/2006
    >
    > when i try to count how many entries are for january i get the following
    > results
    > month count
    > january 1
    > january 1
    >
    > instead of
    > january 2
    >
    > any ideas please
    >
     

Share This Page