Hopefully a quick question:
I have a form that tracks the hours worked by a clerical production staff. I am putting in a new page on the form where the clerk must identify corrections done by item type. They used to report how much time they spent correcting the case. Now we want to build a text box where, once they use a pull-down text box to identify what item type they worked on, the additional text box returns the total time allocated for the item type. I thought that I would have to build an (IF, THEN, ELSE) statement to pull the time from the correct record in the table. Before I went jumping into it, I thought I could run it by you all to see if I am going around my elbow…. Is there an easier way to do this? Can I redesign my capacity table or build a query to make this better?
thanks in advance
christine
