Which Query Should I Use?

[debo33]

All:

I know what I want to do in Access, but I'm not sure how to accompolish this. Here's my problem: I have a table, Training Hours. There are about 12 different courses for 2003 with respective hours(unique CourseID). The hours can increase/decrease by 2004. I want the manager to able to update training hours as necessary in one place, preferrably in the table to make this update. Note: Currently these hours are displayed on forms and reports.

Does anyone have suggestions? (I'm not a programmer, but a beginner. Detailed instructions/example are welcomed)

debo

 

[Dwight]

Here is how I would do it. It is a good idea to keep you users out of your tables. Let them change data in a form instead.

I have attached a sample database with two tables. I added an hours type field to the course ID table. The second table has the actual hours for each hour type. This way you can change it in one place and update it everywhere.

I set up a quick form with a combo box showing you how your users can make the selections.

Check it out and let me know if you have questions.

Dwight

 

[debo33]

Dwight:

You rock, man! This will fit perfectly on the data entry screen. I never thought about a combo box. Many thanks.

Debo