Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
I have an associates table and a travel table (basically a work schedule). I need to be able to have...
I would suggest a new table with a single record entered in it. It will be Record ID of 1 Crea...
Posted 08-18-2017 19:57
I have an associates table and a travel table (basically a work schedule). I need to be able to have a report that will tell me who are those associates that are not working during any given time-frame. I can do this in Excel fairly easily, but I need it in QB.
Any ideas on how to proceed?
RE: unscheduled associates
Posted 08-18-2017 21:50
I would suggest a new table with a single record entered in it. It will be Record ID of 1
Create the start and end dates of your inquiry range.
Then in the travel table make a field called [Link to travel inquiry date range] with a formula of 1
Lookup the inquiry dates down to the travel dates and on the travel dates recor create a checkbox formula fi LD called [Employee is travelling]. Figure out the formula for that.
Then on the the employee record make a summary of the # of active trips during the inquiry period.
Then make a report of employees with no travel records. That will be your answer.
To be more elegant, put a report link field on the single record table and use that report you just creahave ed. When you save the inquiry date range the single record will refresh and your report will be right on that record.
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic