One table with three date fields (all with short dates) can you combine them into one

[jfiresto]

I have a table called Packages, in this table I have multiple fields with just short dates example of fields (ID), (Home_1), (Home_2), (Home_3) and (Home_4). What I was wondering is there a way to comine all of the Home fields into one for the purpose of counting the number of dates for all the records. Total number of dates of all the Home fields? I am using Access 2010

[June7]

This is not normalized data structure. If it were, could do a simple aggregate (Totals) query. Since it is not normalized, use a UNION query to configure the data in normalized arrangement.

SELECT ID, "Home1" AS Source, Home_1 AS DateValue FROM Packages
UNION SELECT ID, "Home2", Home_2 FROM Packages
UNION SELECT ID, "Home3", Home_3 FROM Packages
UNION SELECT ID, "Home4", Home_4 FROM Packages;

There is no wizard or designer for UNION query, must type (or copy/paste) in the SQL View of query designer.

Now use that UNION query as the data source for an aggregate query.