Sorry if I didn’t explain myself very well. What I would like to do is create a report for a daily time card summery with a page header as the employee’s name, along with some miscellaneous information. I have that down. The following is the SQL for my cross tab Query.
TRANSFORM Sum(TTimeCard.ID) AS SumOfID
SELECT TTimeCard.TCDate, TTimeCard.RateDiscription, TTimeCard.EffectiveRate, Round([TotalSeconds]/3600,0) & ':' & Right("00" & Round(((TotalSeconds/3600)-Round(TotalSeconds/3600,0))*60,0),2) AS TotalTime, (Sum(DatePart("h",[TCLTotal])*3600+DatePart("n",[TCLTotal])*60)) AS TotalSeconds, Sum(TTimeCard.ID) AS [Total Of ID]
FROM TTimeCard
WHERE (((TTimeCard.Billed)=False))
GROUP BY TTimeCard.TCDate, TTimeCard.RateDiscription, TTimeCard.EffectiveRate, TTimeCard.Billed
PIVOT TTimeCard.Full_Name;
The Query creates columns for TCDate, RateDiscription, EffectiveRate, TotalTime, TotalSecounds, TotalID, and for each employee name.
On the report I would like to display other information under the group TCDate such as RateDiscription, EffectiveRate, TotalTime only for the selected employee name. How would I build an expression to do this?