Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all:
I have a quick question about comparing dates in the same table.
I have a table with an id field and 3 date fields (id, date1, date2, date3). I would like to create a chart/table that would count(id) by year for each of the dates compared on the same chart/table.
Example:
Year Count(id)_for_date1 Count(id)_for_date2 Count(id)_for_date3
2014 12 24 48
2013 22 49 65
Is this possible? Any help is appreciated....
Thanks
JT
see attachment
see attachment
Thanks ... This works great.