Good morning bmains;

I want to thank yo for all your help! The code works fine but it's displaying all the ticket numbers from Ticket_Number table. What I'm trying to do is to have the user fill out that form then on the confirmation page print out a ticket number from the database. For example This user would be number 10. It would grab that number from the sql database then print out on the confirmation page.

Again thank you !

Hello,

You have to limit the query with the where clause then, based on some parameter. I'm a little confused. Are you inserting a user request into the database and then grabbing the identity value? If so, basically you would do the insert, and then do a:

SELECT max(Ticket_Number) FROM Escalation_Forms where UserID = '" & strUserID & "'"

Brian

No the user fills out the form hit submit then the confirmation page displays the highest or a unique ticket number from the database.

Ralph

Hello,

So would the previous query work? Are the ticket numbers already created before this? Does the request get inserted into the database and the Ticket_number is a identity field?

Sorry, I'm having trouble following along.

Brian

The Ticket number already created in the data base! I try to get to display only one ticket number from the database or the highest ticket number:

  Her the result I am getting:

Form confirmation

Thank you for submitting the following information!

 Your Ticket Number is:

85
86
90
96
99
104
87
88
94
102
103
105
106
89
92
93
95
97
101
91
98
100


 Date of Request: Tuesday, June 29, 2004

Hey,

Selecting the highest number is easy then, do:

SELECT max(Ticket_Number) FROM Escalation_Forms

You have to delete the ticket number from the table or else it will always be the highest.

Brian

Bmains;

I want to say thank you for walking me through this problem I had!

God bless!

Ralph