I need to add coHours and BaseBidHours and then compare to SumofActHours all per CodeID 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.

Database Diagram

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.