>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.

I don't think you can easily implement it in SQL. May be through UDF... Perhaps it's better to add an empty place holder to your select and do replace all with recno() after...