MS access help please

Discussion in 'OT Technology' started by GuOD, Oct 14, 2004.

  1. GuOD

    GuOD mcflurry diet

    Joined:
    May 19, 2003
    Messages:
    7,366
    Likes Received:
    0
    Location:
    Toronto
    I have a DB with customers who visited during the month of january. I wanted to count the total during the month in 1 row only.

    If I set the date between 1 and 31 of month, it counts how many each day like

    1/1/03 --- 5

    1/6/03 ---- 10

    etc.

    how do I set the group by for the first colum of jan dates to be like 1/*/03?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Create an expression (ie just type this in one of the columns):

    month(visitdate)

    to do it per month/year, you have to add another expression:

    year(visitdate)

    Then you group by those two expressions, and count whatever field you want
     

Share This Page