Incrementing text fields

M

MikeSweet

I have to add about 1,000 records into my database incrementing the number.
Unfortunately the field is a text field. For example the value is 1G200. I
have to make 1,000 more records incrementing the 200 by 1. Is there an easy
way to do this?
 
M

Michel Walsh

Increase a number and then concatenate "G" with that incremented number.


Hoping it may help,
Vanderghast, Access MVP
 
M

MikeSweet

Thanks. I will give it a try.

Michel Walsh said:
Increase a number and then concatenate "G" with that incremented number.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 

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

Template with fields and premade texts.. 0
How to auto create volume bands 6
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Quick way to put all records in email field of query in Bcc of Outlook 2
Link a text box based on drop down box with four options MS Word 365 0
Number of Records in Query 0
Columns appearing from nowhere, formatting going weird 0

Top