What's new

Latest profile posts

Hi,
If you have time, I have posted a thread regarding "current active user". Please have a look.
Many thanks
Hi @arnelgp
If you have time, I have posted a thread regarding "current active user". Please have a look.
Many thanks
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) get a sequential number for each record
2) get a subset of sequential numbers by the invoice number
isladogs
isladogs
@BGIBERT
You should ask this question in the forum thread where you are more likely to get a quick answer
Top Bottom