Recent content by NewbieJeff

Thank you so much, I am sorry for being such a newb. My first table has 1-97,059 records with 01a,01b,02a,02b.......47a,47b as my rowfaces. But I also have a table that has a field that designates the range that looks like this RowFace...... RecIDstart...... RecIDend...

That was helpful but still does not solve my problem.

I can not find this update query in Access 2010.

I am extremely new to Access and I am trying to write to do something I feel should be easy but I am too dumb to figure it out. I am trying to create a new field where it will show a row face for a library. I have a "Record ID" field that goes from 1 to 97059 and for example my first row is...