Jump to content

Creating Unique Key Values

This topic is 7353 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a db: Employment Oppurtinities, that allows a user to create a Job Order and then view eligible candidates (Full-time, Part-time, Both) in a portal. I want to assign a unique identifier (JobOrderCode) to each order that I can in turn assign to candidates meeting that order's criteria. To keep it simple, I want to combine the order date and the record number into a text value. I tried this calculation:


NumToText(Month(Order Date)) + NumToText(Day(Order Date)) + NumToText (Year (Order Date)) + (@@)

where (@@) should be the record number (i.e. 5)

thinking that September 4, 2001 (record 5) would become 9420015

However, the calculation does not accept (@@), and [NumToText(Month(Order Date)) + NumToText(Day(Order Date)) + NumToText (Year (Order Date))] returns a 4 digit number (i.e. 9/4/2001 becomes 2014).

I thought that using NumToText(xx(Order Date)) would convert the numeric values to text and prevent their being added together. What have I missed?

Link to comment
Share on other sites


Originally posted by Afeina Software:

Try it this way:

Status( CurrentDate ) & Status( CurrentRecordID )

This should give you what you are looking for.

Good Luck,

Martin Wiedemann

Thanks Martin; Status(CurrentRecordID) creates great index values! I thought I was going to have to find a way to create "000xx" or some such values to append to the date values.

Link to comment
Share on other sites

This topic is 7353 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    1 member has viewed this topic:
    Tony Diaz 
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.