Custom ID field issue

[ToolJob]

I added a index field whose values look like this:

12-001
12-002
12-003
etc

When I use the following command to get the last ID in the table:

lastID = DLast("NCR_ID", "NCR_RECORDS")

I am expecting 12-029

but I am getting "!29" instead????



Not sure why? I am figuring it is a data type issue, but how do I display an auto-number field (like I am using) as a valid data type so I can get the expected format of 12-xxx??

Thanks


TJ

[orange]

Do NOT use DLast. Databases do not store data in sequential order necessarily.

Google Dmax and Dmax+1

There's a lot of discussion of CustomId's on the net.
Here is a recent discussion that may help put some context of your request/issue.
http://www.access-programmers.co.uk/...d.php?t=244894

[ToolJob]

Do NOT use DLast. Databases do not store data in sequential order necessarily.

Google Dmax and Dmax+1

There's a lot of discussion of CustomId's on the net.
Here is a recent discussion that may help put some context of your request/issue.
www.access-programmers.co.uk/forums/showthread.php?t=244894

Orange, thanks I did change my code to use the Dmax. The issue I am still having is reading the custom ID.

Like I said the last inserted record is 12-029 - when I popup a message box with the value I am getting - "!29"

I am not sure why?

Thanks in advance

TJ

[orange]

Me either. Because of your format you are dealing with a text field.
Where is the autonumber? What processing are you doing with the data?
Why do you have this code 12-029?

[ToolJob]

Me either. Because of your format you are dealing with a text field.
Where is the autonumber? What processing are you doing with the data?
Why do you have this code 12-029?

I wanted to use a custom ID...I wonder if there is a way I can change the auto-number field to 1,2,3,4,5...etc...and than have another column to concatenate the ID field with my customID

so I would take the ID columne value "1"

and concatenate that with "12-XXX" to make "12-001"?

[orange]

see http://www.access-programmers.co.uk/...d.php?t=245259

This has been discussed and a sample database has been provided for download.