Solved: Auto Ticket Number

[Nosstech]

Is there an easy way in Access to assign a ticket/call number that automatically assignes a number to a record?

For instance, if someone calls my desk, I want the ticket number to be mmddyyyy-call (09172008-1, 09172008-2, etc.)

Can this be done?

Thanks

[CreganTur]

Take a look at the attached example database.

The form will look at today's date and then run a DCount against the table to see how many calls have come in for the current day. Then it will increase the number of calls by 1 and create a ticket number in the format you specified: mmddyyyy-#OfCalls ; Example: 09182008-1

HTH:thumb

NinjaEdithttp://img293.imageshack.us/img293/9060/ninja3od8.gif: Oh, and the ticket number is a primary key value- since we don't want to duplicate an existing key.