Append Criteria

[CJ_London]

WHERE ((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 etc

[June7]

sorry that won't necessarily work. If you have an employee of 123 that will also return 1234, 2234, 2341 etc

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.

[CJ_London]

but example is flawed

oops

you could use

WHERE InStr("," & replace([enter nums]," ","") & ",","," & [myTable].[myField] & ",")>0

but that kills any use of indexing

[CORINEREYES]

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.

[CORINEREYES]

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.

Hi Minty,

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.

[CJ_London]

you might find the form example in this link of use
https://www.access-programmers.co.uk...-boxes.323395/

[CORINEREYES]

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.