Access 2013
I have a form (F_WorkingHoursSub) with 3 fields (Workers, Contractors and Total)
Sometimes I have the hours for Workers and Contractors, and other times I only have the Total hours.
I would like the total field to show Workers + Contractors if this data is entered. But... If I only have the total, I would like to be able to enter the total in the total field and show the other two fields blank.
Any suggestions??? My brain is already melted
I have a form (F_WorkingHoursSub) with 3 fields (Workers, Contractors and Total)
Sometimes I have the hours for Workers and Contractors, and other times I only have the Total hours.
I would like the total field to show Workers + Contractors if this data is entered. But... If I only have the total, I would like to be able to enter the total in the total field and show the other two fields blank.
Any suggestions??? My brain is already melted