>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