Criteria in a query, last 5 digits

[Caroline]

Hello,

I am working on a query (PivotData) that has all of my data and trying to
put it in sequence, along with a sequence number that will stay with it. So I
have a Sequence Query, which gives it that number, and then this connects to
the Work Order in the PivotData query with all the data. It works for most of
the work orders. The problem I'm having is when the work orders are not
EXACTLY the same. How can I relate just the last 5 digits of the work orders
to give those that are not exactly the same a sequence number?

Let me know if this makes sense.

Thanks,
Caroline

 

[Caroline]

Ok, but how do I incorporate that? Do I just put that expression in the
criteria section? Do I have to make another query that matches the last 5
digits of work orders from both places? Is it a new field? Thanks

You can get the last five digits (assuming no spaces) with this expression:

Right([PONum],5)

Steve
(e-mail address removed)

Hello,

I am working on a query (PivotData) that has all of my data and trying to
put it in sequence, along with a sequence number that will stay with it.
So I
have a Sequence Query, which gives it that number, and then this connects
to
the Work Order in the PivotData query with all the data. It works for most
of
the work orders. The problem I'm having is when the work orders are not
EXACTLY the same. How can I relate just the last 5 digits of the work
orders
to give those that are not exactly the same a sequence number?

Let me know if this makes sense.

Thanks,
Caroline