sorry that won't necessarily work. If you have an employee of 123 that will also return 1234, 2234, 2341 etcWHERE ((InStr([enter nums],[myTable].[myField])>0));
sorry that won't necessarily work. If you have an employee of 123 that will also return 1234, 2234, 2341 etcWHERE ((InStr([enter nums],[myTable].[myField])>0));
I understand what you meant but example is flawed. 123 would not return 2234 or 2341.
Would have to use a field where values are all same length, such as an assigned EmployeeNumber, not autonumber ID.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
oopsbut example is flawed
you could use
WHERE InStr("," & replace([enter nums]," ","") & ",","," & [myTable].[myField] & ",")>0
but that kills any use of indexing
Hi Orange,
Sorry for my late reply.
Not 5000 employees renew their contracts at the same time. It is according to the month of their hire date, renewal is annual.
The only issue i have is printing transmittal for the some employees . Like the one i attached.
Hi Minty,A multi select list box will work but will be cumbersome with 5000 + records.
In these circumstances I would make a list box with a filter to get you to a more restricted list (Type in "Smith" and it would list all the Smith's for example).
I would have a second list that you would add the selected records to you can add and filter to your hearts content.
Once complete use that second list to drive the query.
I would probably store the selected items in a table called tb_ReportEmpIDs - simply join the report Empid to it, you can use it anywhere you need then.
You could go a stage further and store named lists and then edit them if they get used on a regular basis.
The same list box form would allow you to edit the existing lists.
There is a simple version of this type of thing here:
http://www.baldyweb.com/multiselect.htm
PBaldy's site.
This is the best applicable suggestion , i will apply it and let everyone know the outcome.
I thought append can do the task easier, because i dont want to code and make long and cumbersome method just for the transmittal.
Append criteria works on texts, dates but not with numbers.
Thank you guys for your efforts and suggestions.
you might find the form example in this link of use
https://www.access-programmers.co.uk...-boxes.323395/
This is useful for my project, thanks so much.you might find the form example in this link of use
https://www.access-programmers.co.uk...-boxes.323395/