Hi Guys

[warriorgift]

how to do a ticket with increment Number with access

like that in the bank , when you sign up to take a number



thanks

[mike60smart]

Hi

When you say a Ticket - What type of Ticket?

[warriorgift]

QUEUE MANAGEMENT SYSTEM

Customer waiting order

[CJ_London]

why not just have a datefield with a default value of now()

you can format it as you want to look like a number rather than date/time

or use an autonumber field.

Or if you don't want to risk gaps, google a process called 'dmax()+1'

[warriorgift]

i've 20 Clinics each patient should waiting wthin his sign-in order, so i need to print a ticket with date() , time() , general auto-number and clinic within auto-number

thanks

[CJ_London]

any of the suggestions I've made you can use. As far as the clinic is concerned, that would just be a separate field.

[mike60smart]

When you say 20 Clinics do you mean you have 20 specific Time Slots during the day?

Can you give us a list of the time slots?