Search for string within field for report

  • Thread starter Thread starter Fletcher
  • Start date Start date
F

Fletcher

I don't really know how to explain what it is that I'm looking to do,
but I'll do my best.

I would like to have a report that will show entries from a table that
have a field that contains a certain number combination in it. I'll go
more in depth.

We have lot numbers in our facility that can have extensions on them.
Such as, 12345.A or 67890.B, and sometimes 12345.4C and so on. And
ocassionally they are stored together in the same entry due to
extenuating circumstances in the facility. These look like
12345.A/67890.B

What I want to do is, say, have the report show a summary of all lots
that begin with or contain "12345" or "67890."

Is there any way to do this?

All help is welcome.


FPWL
 
Contains a string

Field: LotNumbers
Criteria: LIKE "*12345*"

Starts with a string
Field: LotNumbers
Criteria: LIKE "12345*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top