Search results

Thanks for the help!!! That worked perfectly! Just one other quetion for you. I want to create a form based on this query but I have a similar type problem if one of the sum columns in my query which is based on two queries is empty then it won't fill out the form. Any thoughts??

Hi I have a query which is supposed to pull up the data from two other queries. If both queries have atleast on result then the 3rd query is working prperly. The problem is if one of the queries returns no results then the query based on the other two queries also displays no results but I...

EX. if the employee only has three jobs one for which he is the designer and two for which he is the checker, and the first job has r1=50 (employee X) and R2 =100 (employeeY), the second job has R1=50 (employeeZ) and R2=100(employeeX) and the third job has r1=50(employee A) and r2=100...

I want to run a query that will run through all of the records and pull out all of the remaining time for a curtain employee. The only problem is the employee could be listed as the designer or the checker. The remaining hours for the design are designated as R1 and the remaining hours for the...

Access Help - Pulling data from Query into a form We have a database that we keep track of all of our projects and the percentage they are complete. I have created a form that runs a query to pull up all the projects that are not yet complete based on the employee you choose. I now what to...