I have a database with two tables. One has employee information the other days of leave an employee takes off. They are related by the employee ID number. An employee gets 20 days off each year, after 5 years they get 25. They can take full days and half days. I have a query that sums up the number of days taken by each employee. I want to be able to have a text box in a form, based on the employee table, that shows that number and also be able to put that number in a field ([TOTALDAYS])for each record in the employee table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filling text boxes
- Thread starter robert693
- Start date
braindead2
Technical User
check into DSUM or DCount functions. Sounds like what you may need.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question