How to make number never go down?

[Darknight850]

Hello,

This question I have may be alittle more difficault. I have a report that shows all of the type of IDs my company has given out. But when they are terminated from the company the number goes down. what i need is a field were the number never goes down, and always goes up, showing me the over all IDs I have issued out. I really have no idea were to start with this, so if any one could help me that would be great. Thank You.

[abolos]

Hello,

This question I have may be alittle more difficault. I have a report that shows all of the type of IDs my company has given out. But when they are terminated from the company the number goes down. what i need is a field were the number never goes down, and always goes up, showing me the over all IDs I have issued out. I really have no idea were to start with this, so if any one could help me that would be great. Thank You.

Can you please explain more about your question?
Thanks,
Abolos

[missinglinq]

Please do as abolos requested, with particular emphasis on how the ID number is generated to begin with , and exactly what you mean by the "number going down."

Linq ;0)>

[NeoPa]

Firstly, please do as Abolos has suggested. If you reread your post you should get a picture of how little information it imparts. When you've done that try to rewrite it so that anyone reading it can get the same understanding you already have.
Having said that, can I hazard a guess at the sort of thing you're talking about.
You're looking for an ID scheme that DOESN'T re-use any previously used ID.
Does it also need to have a one-to-one correlation between IDs and valid users, such that the last one used should always be the total number ever issued?

[Darknight850]

I am sorry i can not give detailed information. But i can try to restate my question, maybe that will help. I will try to make this as simple as possible.

The following tables are the tables that matter in this problem:

tblAll:
EmployeeID - PK
Name
JobTitle
Has ID
CardID - FK

tblIDType:
CardID - PK
ID Type

I have a report that has all these ID types in it, this report counts all the IDs that are selected from a drop down menu in "tblAll". But I also need another text box in my report to count over all given IDs. Meaning that the number in this text box can not go down because it will be counting all of the IDs ever given from now on, so if some one quits I still have that number in this text box, if some on gets a diffrent type of ID i still have the old one in the text box. This is an over all count of all IDs put togeather

Example:
1) txtOverall = 2000
2) John Doe - Quits and is taken out of database
3)txtOverall = 2000 - does not go down.

I am sorry i can not give any more information, i have tried to put this as simple as possible. If you have any questions feel free to ask. I am not sure if this can even be done, i have tried to search the internet anything resembling what i am looking for but i could not find anything, if any one could help it would be greatly appritiated.

Thank You

[Darknight850]

Any one know how to go about this ?

[abolos]

I am sorry i can not give detailed information. But i can try to restate my question, maybe that will help. I will try to make this as simple as possible.

The following tables are the tables that matter in this problem:

tblAll:
EmployeeID - PK
Name
JobTitle
Has ID
CardID - FK

tblIDType:
CardID - PK
ID Type

I have a report that has all these ID types in it, this report counts all the IDs that are selected from a drop down menu in "tblAll". But I also need another text box in my report to count over all given IDs. Meaning that the number in this text box can not go down because it will be counting all of the IDs ever given from now on, so if some one quits I still have that number in this text box, if some on gets a diffrent type of ID i still have the old one in the text box. This is an over all count of all IDs put togeather

Example:
1) txtOverall = 2000
2) John Doe - Quits and is taken out of database
3)txtOverall = 2000 - does not go down.

I am sorry i can not give any more information, i have tried to put this as simple as possible. If you have any questions feel free to ask. I am not sure if this can even be done, i have tried to search the internet anything resembling what i am looking for but i could not find anything, if any one could help it would be greatly appritiated.

Thank You

Try not to delete the record, just mark it as deleted programatically. Add a field named Deleted and make its type Yes/No. When you delete the name then the Deleted will be Yes. And then make a query so that not to show you the Yes data. This will now show the deleted data for you, but will keep having it in its calculation.

Hope you are happy with this.
Abolos

[Darknight850]

Try not to delete the record, just mark it as deleted programatically. Add a field named Deleted and make its type Yes/No. When you delete the name then the Deleted will be Yes. And then make a query so that not to show you the Yes data. This will now show the deleted data for you, but will keep having it in its calculation.

Hope you are happy with this.
Abolos

Thank You. I thought that may be the only way to go about it.