Search results

I have attached a screenshot of my table relationships. I am attempting to develop a database to 1) Manage Jobs 2) Monitor Production 3) Track Inventory. I believe that the bulk of my design is correct, but I know that I have several problems.... 1. tblJobSetup - Originally, the database was...

I am querying the sum of delay time per job. The query successfully returns these sums, but does not return a value for a job if no delays occured. How do I make the query generate "0" for jobs which contained no delays.

Combo2 list items are based on the selection made in Combo1. The list displays correct the first time a selection is made in Combo1, but does not update if a new selection is made. Combo1 = JobNum_Combo Combo2 = ODWall_Combo After Update Event Procedure..... Private Sub...

Also posted in the Forms forum....possibly a few more responses and help can be generated here. http://www.access-programmers.co.uk/forums/showthread.php?t=136556

Assumptions: -Multiple Jobs can be peformed in one day (queiries must be able to display all jobs performed on a selected day) -Multiple Delays will occur within each job. Crucial Form Fields: -Date, ProductionStartTime, ProductionEndTime Crucial SubForm Fields (To Enter Production...

JobSetup Table contains the following columns.... JobID (Primary Key, Autonumber), JobNum, SubCode, Customer, Project_Lease, JobDetails *The database will contain many duplicate Job Numbers(all with the same Customer/Project_Lease), but the JobDetails within the JobNumbers will ALWAYS be...