Recent content by BGIBERT

  1. B

    Yesterday you provided the SQL select id, invoice, dcount("1", "yourTableName", "ID <= "...

    Yesterday you provided the SQL select id, invoice, dcount("1", "yourTableName", "ID <= " & [ID]) As Sequence, Status from yourTableName Order By id Asc; I do not have an ID value. To simplify, assume a table of only invoice numbers with duplicates. How would I change your SQL to: 1)...
  2. B

    Sequential Numbers in a query

    Thanks for all the good advice!
  3. B

    Sequential Numbers in a query

    Status is insignificant. Just need to Status is insignificant. I complicated the issue by introducing this field in my question. I just need do determine how to create a sequence of numbers that restarts at 1 for each change in invoice. I'd also like to know how to generate an ID number...
  4. B

    Sequential Numbers in a query

    Hello to all. I am new to this forum and have a problem that I am sure has an easy fix. I have a table of invoices that contains duplicate invoices. (There should be no duplicate invoices.) I have a query that identifies only the duplicate values, and a row exists for each duplicate invoice...
  5. B

    Hello All!!!

    I have used Access for years very sporadically. Know just enough to constantly get myself in trouble. I look forward to the knowledge and experience that is housed in this forum.
Top Bottom