Write the first digit, only

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!

I have records with numeric IdNum and others fields.
When is assumed, in query, the fix digit=1, for exemple:
Like 1 & "*"
very well but, in this time, I would like to write the 1st
numeric digit when run query and assume remaining it.
I try some others hipothesys but don't work.
I would like help, please
Thanks in advance.
an
 
Your question is not clear. Are you saying that you would like the query to
prompt you for the first digit when you run the query? If so, use criteria
like...



Like [EnterFirstDigit] & "*"




Rick B

Hello!

I have records with numeric IdNum and others fields.
When is assumed, in query, the fix digit=1, for exemple:
Like 1 & "*"
very well but, in this time, I would like to write the 1st
numeric digit when run query and assume remaining it.
I try some others hipothesys but don't work.
I would like help, please
Thanks in advance.
an
 
Thanks for your reply.
Sorry for my bad explanation but the your solution work
fine.
Thank you for your help!
an
 
Back
Top