V
Vicky
Hi,
Hope someone can help. I'v been asked to create a report
based on a time and day entered by the user. This is to
schedule meetings. The problem is that the query is to
complex to base the report on a simply query. The
variables that I am dealing with are beginning time,
instructor names and day. I have the code writen to
validate all the data, I'm storing instructor names that
can't be available for the meeting in an array, but I
don't know how to have the report print or display
instructors who's name is not in the array. Do I use a SQL
statement, and if so what would it be. I have tried sub-
queries, but could not get them to work.
Vicky
Hope someone can help. I'v been asked to create a report
based on a time and day entered by the user. This is to
schedule meetings. The problem is that the query is to
complex to base the report on a simply query. The
variables that I am dealing with are beginning time,
instructor names and day. I have the code writen to
validate all the data, I'm storing instructor names that
can't be available for the meeting in an array, but I
don't know how to have the report print or display
instructors who's name is not in the array. Do I use a SQL
statement, and if so what would it be. I have tried sub-
queries, but could not get them to work.
Vicky