Hello all I have a cross table query which gives me:
- Names along the top
- Times down the side
- Appointment details in the detail bit as below
TRANSFORM First(tblappts.HavingDone) AS FirstOfHavingDone
SELECT tblappts.Time
FROM tbltimes RIGHT JOIN tblappts ON tbltimes.Times = tblappts.Time
WHERE (((tblappts.ApptDate)=[Forms]![frmmain]![appt3]))
GROUP BY tbltimes.Times, tblappts.Time
PIVOT tblappts.Stylist;
Is there a way where i can get all the times to show on the row headings even if there is not an appointment associated with it
any help appreciated thanks