question

LopezAhiezer-8335 avatar image
0 Votes"
LopezAhiezer-8335 asked thedbguy answered

How can I filter a form using multiple records within a field?

Say I have a field named Project and within that field I have multiple 6 digit numbers. I have a form that has all the records showing all the different 6 digit numbers but now I only want the form to show all the records with a project number of '123456', '012345', '63*', and '121212'. How can I add a filtering option?

office-vba-devoffice-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TvanStiphout avatar image
0 Votes"
TvanStiphout answered

You can OR the values together. Say you have some values sitting in txt1 through 4
... " where Project like " & Me.txt1 & " or Project like " & Me.txt2 ... etc.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

Just FYI, crossposted here...

Microsoft Community


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.