I need to add
BaseBidHours and then compare to
SumofActHours all per
jobID. See image below.
I only loaded everything in to one query to visualize all the tables. Any thoughts would be awesome, still relatively new to access and DB's in general. I imagine I will need to nest several queries?
Sorry I don't know how to explain this any better.