Hi Steve,

What type of database is it? Also, what is the name of the table and the
name/data type of the quote number column? Are you connecting through ADO
over OLEDB?

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

steve wrote:
I have a database that tracks Quotes. On a userform (that
reads/writes to the database) i have a button that inserts the quote
number.

if the user is quoting a new job, i search the 'Quote Numbe' column
for the max, then add 1 to it for the new job number. This works
fine.

the problem is ifI the user is Re-Quoting a job, i just want to add
0.1 to that Quote Number from the Originial time it was quoted.

Example:
if a job was quoted once, and received a Quote Number 5000. If the
user wants to quote that job again, i want the quote number to be
5000.1
then if he wanted to quote it a third time, it would be 5000.2

I just need a way to look for the project name
(ComboBoxProjectName.Value) in column A of the database, then add 0.1
to the largest number for that project.