New profile posts

What's new Featured content New posts New profile posts Latest activity
B
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
C
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.
S
Hi CJ_London
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
B
Hi Everybody, I am new in this forum. I am learning VBA programming for Excel and Access. Would like to upgrade myself with the vast knowledge base available in this forum. In profession, I am a Mechanical / Piping Engineer, living in Thane, Maharashtra, India.
Regards,
Bibek.
D
I'm new to this forum and just joined today. I am an Access Developer for our local Food Shelf, but I am not a programmer and usually need help to use SQL. I taught myself the Access from online videos and chats. Hopefully I won't need to much additional help, but it's nice to know that this site is available. Thank you,
M
hello .. hope you are fine
i need to make a list box field in an access table its value depends on the value of another list box >>
Example a field2 is a list box its values appears depends on the value i chosen from field1 list box ,, so
i made a table for field1 values and another table for values of each value in field1
how could i control it
S
Hi, I am reaching out to you because of your Export to Excel with Conditional Formatting post. I am having a hard time tracking it all but I see that you got it working i have been searching for this answer for a while can I see your finishing code I cannot seem to figure this one out please help!
Back
Top Bottom