Tech Support Guy banner
Status
Not open for further replies.
41 - 54 of 54 Posts
Discussion starter · #45 ·
yes, but now the date "double booked" does not work.

I need the names to come up instead of the ID, and the date double booking.
 
Discussion starter · #47 ·
Right, i sorted the room booking.. its working AOK. It even comes up with the names of staff and the name of the room. And it all shows in the report! :)

BUT.. now i have a problem...

The resources form will not let me select the option.. it states "control cannot be editited, it is bound to..." Could you please try fixing this if possible as iv run out of ideas now and its becoming a real headache for the n00bness that i am.
 
Discussion starter · #51 ·
Okay yeah but now its coming up:
the specified field "resource" could refer to more than one table listed in the FROM clause of your SQL statement."
 
I suppose it comes up in the Date check?
As I said before you want one query for the Form and one query for the Report.
The form one only has one instance of the Resource field on it to avoid confusion.
 
41 - 54 of 54 Posts
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top