1 field value print several text box or label

[meenctg]

I have i field in my table "Id" here i have inputed 16 digit number always. Can i print out every digit with different text box or label in my report? If is it possible by program please tell me how to? It will be very helpful for me.......

 

[Geotch]

You can use the left, right, mid function to do this in a query. Then base the report off of your query.

id=9834567891011121
1st digit:left([id],1) = 9
2nd digit: mid([id],2,1)=8
3rd digit: mid([id],3,1)=3 and so on

also try out the right([id],1 and see how that works. You'll use these all the time, even in Excel.

 

[meenctg]

You can use the left, right, mid function to do this in a query. Then base the report off of your query.

id=9834567891011121
1st digit:left([id],1) = 9
2nd digit: mid([id],2,1)=8
3rd digit: mid([id],3,1)=3 and so on

also try out the right([id],1 and see how that works. You'll use these all the time, even in Excel.

I can print out first 3 digit or right first 3 digit according to your formula, but i can't go ahead. Please tell me details

 

[Geotch]

id=9834567891011121
1st digit:left([id],1) = 9
2nd digit: mid([id],2,1)=8
3rd digit: mid([id],3,1)=3 and so on

You need to understand what the mid function is doing.
4th digit: mid([id],4,1)= 4 since the 4th digit in your field is 4 - 9834567891011121

Does this make sense now?

 

[meenctg]

id=9834567891011121
1st digit:left([id],1) = 9
2nd digit: mid([id],2,1)=8
3rd digit: mid([id],3,1)=3 and so on

You need to understand what the mid function is doing.
4th digit: mid([id],4,1)= 4 since the 4th digit in your field is 4 - 9834567891011121

Does this make sense now?

Yes, Thank you for your response