Hi all, I have a cross table query with
1. Looks up 'Date()' for todays appts
2. Looks up 'Date()+1' for tomorrows appointments
but when i try to run the query with:
=[Forms]![frmmain]![appt3]))
in other words just looks at the date in the date field on main form, it returns that the database engine does not recognise '[Forms]![frmmain]![appt3]))' as a valid field name or expression; here is my sql below, ca anybody tell me where i'm going wrong as all my other lookup queries are fine:
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;
Furthermore, is there a way wher i can get all the times to show on the row headings even if there is not an appt associated with it
any help appreciated thanks
1. Looks up 'Date()' for todays appts
2. Looks up 'Date()+1' for tomorrows appointments
but when i try to run the query with:
=[Forms]![frmmain]![appt3]))
in other words just looks at the date in the date field on main form, it returns that the database engine does not recognise '[Forms]![frmmain]![appt3]))' as a valid field name or expression; here is my sql below, ca anybody tell me where i'm going wrong as all my other lookup queries are fine:
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;
Furthermore, is there a way wher i can get all the times to show on the row headings even if there is not an appt associated with it
any help appreciated thanks
Last edited:
