Using Totals Query for next query to show further values that were not included in totals query (like note field)

[TB11]

Hi. I'm stuck.

My table:
IDProjectTask
fkProject
fkTask This involves just 6 different tasks.
DateTask
TimeTask
fkTaskStatus
TaskNote

My totals query, to give me the latest DateTimeTask for each fkTask.
fkTask - grouped by
DateTimeTask - Max. Formula is [as I added DateTask + TimeTask] Max([DateTask]+[TimeTask])

My problem: I can't get to the point where I can use the totals query in a second query in which I can add the TaskNote, fkTaskStatus and IdProjectTask fields, without getting more results than the totals query. I just can't figure out what I am missing.

Thanks.

 

[arnelgp]

use Sub-Query.

 

[TB11]

@Pat Hartman I want both the aggregate query to get the last date for a project task, then a details query to show the details, like the note field, of that last project task.

@arnelgp That's where I am stuck. I have tried several different sub-queries, but each has given me more entries than what is involved in the totals query.

 

[arnelgp]

can you can upload a sample table?

 

[TB11]

@Pat Hartman and @arnelgp Thank you, I have been tying to figure this out for awhile. You both got me thinking on a different approach, and I solved it.

The answer, should anyone else have the same issue: the first query is the aggregate query. The second, sub-query, is based on the totals query (which I included the DateTask field instead of the DateTimeTask calculated field), with joins from the totals query to the original table to the fkTask and the DateTask fields.

.