Record Count

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

I want to add a text box to a form that will count the
the number of records in the database, and then add one
to that number, based on the text value in another text
box. What I am trying to do is add records that keep
track of software issues. I want to be able to generate
the next software issue number based on application
codes. I have tried DSum, but I am not having any luck
with it. Does anyone have any ideas?
 
What I am trying to do is add records that keep
track of software issues. I want to be able to generate
the next software issue number based on application
codes. I have tried DSum, but I am not having any luck
Click to expand...

I would seriously think about using DMax in order to return the highest-so-
far (and add one to that), rather than getting the count of records. If one
record gets deleted for any reason, the count is going to be short and you
will end up with duplicates.

HTH


Tim F
 
Back
Top