Hi. I have 2 tables.
Table1 IDProject, ProjectDate (this table has only 1 date per IDProject)
Table 2 IDProjectGroup, fkProject, GroupDate (this table has 1 or multiple dates, all relating to the IDProject from table 1, but the date in table 2 is not a duplicate of date from table 1)
Wish list for query: I would like to have one column for a totals query, that shows both the ProjectDate from table 1 and the GroupDate from table 2. I need this single column for count, min and max in the totals query.
I can't seem to get the single column needed. I've tried different inner joins, no joins, separate queries, etc.
Is this something I can do with a query or do I need to restructure table 1?
Table1 IDProject, ProjectDate (this table has only 1 date per IDProject)
Table 2 IDProjectGroup, fkProject, GroupDate (this table has 1 or multiple dates, all relating to the IDProject from table 1, but the date in table 2 is not a duplicate of date from table 1)
Wish list for query: I would like to have one column for a totals query, that shows both the ProjectDate from table 1 and the GroupDate from table 2. I need this single column for count, min and max in the totals query.
I can't seem to get the single column needed. I've tried different inner joins, no joins, separate queries, etc.
Is this something I can do with a query or do I need to restructure table 1?