Tom Farrar
asked on
Need To Create 8-digit field with variable starting points...
So I have an original field in Access as shown below and I need to create an 8-digit field beginning with 370.... similar to the example below:
Original Field Eight Digit Field
544 37000544
33 37000033
254 37000254
Is there a function within Access that would enable me to do this? Thanks. - Tom
Original Field Eight Digit Field
544 37000544
33 37000033
254 37000254
Is there a function within Access that would enable me to do this? Thanks. - Tom
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you saying that fixes the variable length of the 544 (0r 33) field size to give me an eight-digit field ..Yes, that what you asked for. Press Ctrl+G and check out for yourself.
That said, if you just want this for display, it would be much easier simply to apply to format 37000000 to the Format property of your textbox in your form or report.
/gustav
ASKER
I learn something new most days here at Expert Exchange. Thanks again. - Tom
ASKER
37000554
37000033?