quick help if at all possible.
ASPX / Access
I have a table that stores the date (dd/mm/yyyy) in one column and the name of the person assined to that row in another.
Its currently setup in excel but id like something avail to everyone and hosted off a spare workstation here.
I would like to count how many records are assigned in total for the month and then a total for the selected year.
Simlar to
NAME DATE
bob 22/06/2006
There are two criteria month and year these can be seperate queries as they will be shown at the same time.
If i select 06 as the month it will count 1 and return that value to a label called June.
I have two txt boxes so I can enter a month value and a year value, and when theyre blank then it just selects * from the table.
Any ideas as i have little experiance referencing dates or something similar on the net!
ASPX / Access
I have a table that stores the date (dd/mm/yyyy) in one column and the name of the person assined to that row in another.
Its currently setup in excel but id like something avail to everyone and hosted off a spare workstation here.
I would like to count how many records are assigned in total for the month and then a total for the selected year.
Simlar to
NAME DATE
bob 22/06/2006
There are two criteria month and year these can be seperate queries as they will be shown at the same time.
If i select 06 as the month it will count 1 and return that value to a label called June.
I have two txt boxes so I can enter a month value and a year value, and when theyre blank then it just selects * from the table.
Any ideas as i have little experiance referencing dates or something similar on the net!