Generate Unique report number

[subtilty]

Hi There I have built a ticket system with form on Access.

I wish to have a report number made up of

FT,MM,YY,ID of the case

So like this today's date is 09/02/12 and the ID of the record is 26 it would be.

FT021226

Could you please advise me how :) many thanks

[NeoPa]

There are two vastly different answers to this depending on whether the question is about VBA or SQL. The question should have included this important information of course!

VBA :

Something = Format(Date, "FTmmyy") & [ID]

SQL :

Format(Date,'FTmmyy') & [ID]) AS [ReportNumber]

[subtilty]

Hi NeoPa,

Thank's very much.. It was as VBA sorry for the confusion.

However when I try and use [ID] it error's with:

runtime error 2465- "Microsoft access cant find the field "I" referred to in your expression"

I think it would need to detect the last ID and add 1 to it. Is that possible? Thanks

[NeoPa]

I'm good, but not that good. Reading minds is something I'm still working on. The problem here is that you haven't provided a question that anyone can sensibly work with. This is unfortunate as there are threads in this forum which are there specifically to help you do that.

Nevertheless, I've provided the information requested, even if I was unable to use the items you have available to you. I would have thought that you would know how to refer to the ID item (It's not very clear even what type of an item you have so there was little I could do to help on that score) as you presumably must know what your question is about, even if we cannot (yet).

The solution is to provide the basics of the question and get a fuller answer to this question. That doesn't include changing the question. If you'd like to ask a question about something else then please do so, but not in this thread. Detecting the last [ID] value is possible, but if you need to ask about that then a new thread is required (Please give proper consideration to how that question is presented before posting it).