Hello,
I have the following situation:
I have a a table (tblJobs) of job numbers
I have a table (tblWorkHours) of work hours, each of which is tied to a set job number.
I would like a query to select the work hours based on the job number i select, but i would like to do so using a textbox in a form, separated by commas to be able to select multiple job numbers.
For example, if i want to see the hours for job number 2 and 4 and 5 i would like to type in: "3,4,5" into a textbox and have the query return the corresponding WorkHours accordingly.
Also it would be great is i could type "ALL" into the textbox and have it display the WorkHours for all the job numbers
Any suggestions on how i can achieve this?
I have the following situation:
I have a a table (tblJobs) of job numbers
I have a table (tblWorkHours) of work hours, each of which is tied to a set job number.
I would like a query to select the work hours based on the job number i select, but i would like to do so using a textbox in a form, separated by commas to be able to select multiple job numbers.
For example, if i want to see the hours for job number 2 and 4 and 5 i would like to type in: "3,4,5" into a textbox and have the query return the corresponding WorkHours accordingly.
Also it would be great is i could type "ALL" into the textbox and have it display the WorkHours for all the job numbers
Any suggestions on how i can achieve this?