combine autonumber & text

[tinyevil777]

Hi there,

I want each record to begin with SR100, and then the autonumber add the incremented number to it.

For example:

SR1001
SR1002
SR1003
...
...
...
SR10050

Is this possible to do?

Thank you!


Tom

 

[jdraw]

Why? Why the string and autonumber?

 

[tinyevil777]

Because i require the unique reference number to contain both text and an incrementing number.

This is not uncommon, invoices/receipts and credits all have the same functionality, i'm just not sure how to do it.

 

[boblarson]

In the QUERY to DISPLAY it on the form or report just use:

NewFieldName:"SR" & [AutoNumberFieldNameHere]

 

[tinyevil777]

I'm not actually using any queries to display the AutoNumber on the form. That is incrementally naturally from the settings in the Table Setup.

I've uploaded a picture to show you how i've got the field set up, can you tell me what i'm doing wrong?

Thank you so much!

i52.photobucket.com/albums/g29/coolaspeas/untitled.jpg

 

[boblarson]

I can't see any photos uploaded to public file sharing sites - they are blocked by my workplace. I don't usually recommend setting this at the table level but you can, in the FORMAT property of the field put:

"SR"#

 

[tinyevil777]

Just tried that, and it didn't work. Thanks for your help though. I'd like to use a query but i'm not sure how and what to do.

Thanks for your help so far, if you could possibly break it down for me, that would be a great help!

 

[boblarson]

Just tried that, and it didn't work.

When you say "It didn't work." Can you be a little more specific? I had tested it exactly as written in my own test database and it worked fine. What isn't working?

 

[tinyevil777]

I just tried it with a new form, and it seems to have worked, not quite sure why it wouldn't have worked with my old form though... i set them up exactly the same... nevermind, thanks for your help!