Recent content by terry518

It's to make it more convenient for the users here that arent very computer literate

There are duplicates in the other table because the other table holds training information for the employee's entered. It uses those ID numbers to link the tables and people will have multiple types of training. So there are multiple entries in that table under the one employee ID number.

Okay I have a form that gathers employee information and I need to take down an employee ID that you just use the next available number. Is there any way that I can make it so that when you are entering a new employee the ID number automatically puts in the next available number. It can't be...

Okay I have a report that I use to pick out a single employee and show all the training information for that employee. Is there any way that I could make it so that I could pick out multiple employee's and show them on a report. Thanks Terry

Okay I have two forms gathering information. The first form gets the employee's last name, first name, ID num, and department. The second form gets the training information they've done and they are linked by the ID num. When they are entering the training information in the form they choose...

Thanks Thanks, I feel dumb I should've known that.

In my report I'm adding up the cost of training. How do I get my expression to add the numbers and display it as a money amount? Thanks Terry

Okay I finally understand what I need to do, but I have one more problem. I have 12 departments to choose from. So I made my table with the departments, then my form with the combo box with the departments, and my query to restrict the report. The problem is that when I open up the form with...

Ok The problem starts off with my 2 tables. One has employee information like name, ID number, and department. The other has training information such as what you were trained in and etc. The employee information has a column for what department they are in. I need to know how to create a...