>I want my results to have 1,2,3...99 in one of the fields. I thought there was a field type that would allow me to do this, but I can't seem to locate it.

You mean autoinc (part of table creation)?

create table myTable (myOrder i autoinc, ...)
Cetin