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.
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.