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
 

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

Similar Threads

How to combine year and month into one field 3
Fromatting two digit Hour 1
10 digit date 2
Replace first Digit 2
Truncating Results 10
Query with Zip Code Mis-match (5 digit vs 9 digit) 2
contains criteria 2
compute, assign and total values in a query? 4

Back
Top