Ask The User Exact Search
Hi, I have a report that asks the user to input a value and returns the result. I am searching for Asset records assigned to a user, or client. Because these clients are formatted with "HFT" and le...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
I suggest that you make a formula numeric field literally called
[Enter the numeric Store Number with no leading zeros]
Then make a formula of ToNumber(NotLeft([Client Store Number],3))
The use that field in the <ask the user> report with a test of equals.
.