Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report for all data not in a table

Status
Not open for further replies.

sarahnice

Technical User
Nov 18, 2002
101
IE
Hi,

I have a table that contains date information. This is a table of bookings for an individual. The table also has a field for the hour that the task is due to start and also a field for the number of hours the task will take.

I am trying to create a report that will display all the free time an individual has. Is there some way i can check the table and return, for each date, all the time the person is free.

Basically, what i want is to report on all the data that is NOT in a table.

Thanks
 
I would really appreciate if someone could help with this or point me in the right direction. This is really urgent.
 
just a thought - try adding a field to your table that is "total" hours - then have a query subtract free-total to get your answer.

PDUNCAN - MEMPHIS, TN

When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top