Just having FUN! Making a DB for my local volunteer Fire Dept
New profile posts
I am here to solve your Access problems.
-
I
Ihk wrote on arnelgp's profile.
Hi @arnelgp
If you have time, I have posted a thread regarding "current active user". Please have a look.
Many thanks
If you have time, I have posted a thread regarding "current active user". Please have a look.
Highlight currently logged users in access / Mark user as active at the moment
Hi, I have multiple user login based access database. There is table with name""UsersActivity". I created a form based on this table. I want to highlight users whose status is still logged in but not logged out yet from the the database. There are three fields in form (taken from table), and a...
www.access-programmers.co.uk
-
B
BGIBERT wrote on arnelgp's profile.
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
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
Good evening. Just joined today to find out answers for of my questions and hope I can help resolve some issues, though. Still a learner.
Glasgow, UK