Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smopitz

    Adding the row number or a similar sequence column in a Query

    This incremental field has been working great the last few weeks! But it gets into the 1000's by the end of the query. Now I'm hoping to add one more feature. Is there a way to make the incremental column reset back to "1" each time the 2nd column changes data? The second column, [Work...
  2. smopitz

    Adding the row number or a similar sequence column in a Query

    Thank you Remou! I never knew what a module was before, but now read up on it, and pasted the code in there, and now the query worked perfectly! Thank you for your patience! This is opening up a whole new world for me in Access.
  3. smopitz

    Adding the row number or a similar sequence column in a Query

    Now I get the following error: Undefined Function 'IncrementValues' in expression.
  4. smopitz

    Adding the row number or a similar sequence column in a Query

    Thanks, You're right Remou, and I apologize for my oversight. my problem is that my coding experience in Access is terrible, and I don't know how to add a function like the one suggested into Query:Design View. global IncrementVariable as Long function IncrementValues(i) as Long...
  5. smopitz

    Adding the row number or a similar sequence column in a Query

    I am running a query that is re-sorting (reprioritizing) a simple work order table based on the table’s 4 priority-setting fields. How can I add a new column to the query that is an incrementally-numbered sequence - similar to pulling the row number? The "Work Order" id field originally was...

Part and Inventory Search

Back
Top