Recent content by prchrj

Problem Solved! Thank you for the line of questioning, it sparked some rethought as to the design. Have a great weekend.

Yes I did and it came back with a popup wanting me to enter "Rate". So it is not seeing the rate in the query. I appreciate your help, but I have to go for the day. Be back on Monday, have a great weekend.

Ok, I have a table "tblMain" that has three fields. First Field is Employee which is a combo box, TotalHours and Type. The Employee field is a combo box that is linked to another tblEmployee, which has two fields, "Name" and "Rate". When I open the tblMain and select an employee, it shows...

That make sense. Here's my dilemma. I have a field "Employee" that has two fields in it that comes from another table. I can see Name and Rate in the field, but I can't seem to get the calc to see the rate part of the field. Any suggestions? If it was Excel I would reference, for example...

I have two tables. One is tblMain, with employee as a combo box, TotalHours, and Cost field. The second table is employee and it has two fields, Name and Rate. I am trying to do a calculation in the tblMain Cost field that multiplies the TotalHours with the second field "Rate" in that is...

Hello all, I am an intermediate user that has been away from Access for a while. Getting back into it and looking forward to helping or receiving help from this forum. I am in Northern California working at a manufacturing plant that makes lumber industry equipment. Thank you.