I am trying to get results from the current record and can't for the life of me figure it out (it's probably something easy - I'm just missing it).



Basically, I have a form with a sub-form. The sub-form is from a query that calculates the days spent on a certain task. For instance, a Start Date minus End Date = Time. Each task has a start and end date so there can be several instances of a task and several instances of Time.

I have created a Crosstab query that sums up the number of days for each task, per Rec Number. In other words:

Record 1 contains

Status Start Date End Date TotalDays
In queue 1/10/06 1/15/06 5
Active 1/15/06 1/17/06 2
Review 1/17/06 1/18/06 1
Active 1/18/06 1/19/06 1
Complete 1/20/06 1/20/06 1


Record 2 contains

Status Start Date End Date TotalDays
In queue 2/10/06 2/13/06 3
Active 2/13/06 2/17/06 4
Review 2/17/06 2/18/06 1
Active 2/18/06 2/19/06 1
Complete 2/20/06 2/20/06 1

The output from the crosstab query looks like this:

Status Record 1 Record 2
In queue 5 3
Active 3 5
Review 1 1
Complete 1 1

All I want to see is the results from Record 1 when I'm on record 1. When I'm on record 2, I only want to see the results from record 2.

Is this doable?

Any help is greatly appreciated.
Anne