View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Database Question

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.