I am here to solve your Access problems.
New profile posts
-
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
-
S
sunkerala wrote on CJ_London's profile.
Hi CJ_London
could You please look at my thread, if you are not busy
could You please look at my thread, if you are not busy
How to make a consolidated Report
Hi all... I am developing my first access app for building construction work purpose Actually all I want is to make monthly progress reports to submit to my boss This is my masterTable Project Name | Locality | EstimatedCost | Stage1CompletedDate | Stage2CompletedDate | Stage3Date | etc...
www.access-programmers.co.uk