Re: show numbers not in the list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Just FYI, it is customary to retain these people but mark them as inactive.
What if they come back? What if you want to run reports for this year? Are
their numbers used in any other parts of your database? In other words, do
you enter their numbers in an invoice as the salesperson?

If it were me, I'd mark them inactive instead (maybe even put in the
termination date). And leave them out there for at least a year.

Just my opnion.

--
Rick B



"Troy" <Troy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:085B65CF-DBB7-4252-8B50-E76B3F21A142@xxxxxxxxxxxxxxxx
> I have a numeric field that is my primary key. It is employee number (3
> digits) and when someone quits we delete them from the database. I need to
> know what numbers are free for new employees. Is there a way to do this?
>
> Thanks!


.

Relevant Pages

  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... the database down to its knees. ... Cartesian products that mistakingly return 100x the number of rows they ... What would an employee be for you? ... balance to other reports. ...
    (comp.object)
  • Re: show numbers not in the list
    ... "Rick B" wrote: ... it is customary to retain these people but mark them as inactive. ... It is employee number (3 ... >> digits) and when someone quits we delete them from the database. ...
    (microsoft.public.access.queries)
  • Import from Excel chart
    ... I have a table in my database that holds the number of hours worked by each ... employee each day. ... information in this table is used in running statistical reports. ... report and put it into the EmpTime table? ...
    (microsoft.public.access.externaldata)
  • Re: Help with SubForms
    ... you should not use Reports as a Table Name -- it is an Access ... A Yes/No field in the Boats Table, if so, could replace the Boat# ... Table and simplify the structure of your database. ... > 4st Employee# ...
    (microsoft.public.access.forms)
  • Re: Host based IDS Reports
    ... On Sat, 2003-12-20 at 14:05, Teicher, Mark wrote: ... As long as the data was being reported to a database, ... own reports, import to Excel and pretty them up from there. ... We also stress SQL skills as one of our main requirements for new ...
    (Focus-IDS)