Access database problem..help

[Acternaweb]

Hi,

I need a great deal of help. My records are no longer in order. My ID# (auto created) no differs from the record number. For example
Record 24 is ID# 47. No idea how it happened but is there a way to put the records in numeric order so that the record and id are in sync? It started that way, and now sure how/what changed.

Thanks so much

[john316]

I would use bbedit to remove/add line numbers.

I don't know what you could use on a windows machine.

[Woz]

This is normal behaviour as the Auto-ID number is used once and only once per table. So if a record is deleted, then that ID number is also deleted and no-longer available. The reason is that the Auto-ID is sequential from the last ID created. So if you have ID 1, 2, 3, and then delete record #2, then creat a new record, it will be record #4.

Don't try to correlate Auto-ID with record number in listings, simply us the ID for administrative purposes and otherwise ignore it.

Onya
Woz

PS, you cannot edit ID numbers, don't even try.

[Acternaweb]

Thanks Woz, you seem pretty knowledge with access. As I newbie to access, I have one other question I hope you can help with. I have several fields that I want to evaluate;
(price paid, value then, current value) I want to create a blank field that will evaluate to see if the price paid is greater or less than the current value and if the current value is greater or less than the value then. Is it possible?

Thanks for your help

[TallTroll]

It sounds like you need to create a control(s) which will take the required info from the table(s) that hold the information, and display it

Controls are objects on a form, report, or data access page that display data, and you can set them to relate to other information held in tables or queries

You seem to need one control that performs price paid > current value, and one that does current value > value then.

Unless you simply want to display the fields side by side? Then you just need a form that displays current value versus value then, and price paid > current value

Does that make sense?

[Acternaweb]

Thanks TallTroll
Is there a wizard for controls? I saw on the forms toolbox it is an icon for more controls, but don't know what I would be looking for.

Would an expression work, where I put the phyiscal equation into the field?

Thanks for your help