Rank business days

[Alhakeem1977]

I have got a table called deptSeq extracts the business days for the whole year as the below:
PK DDate Dept
1. 02-Jan-19 OFS
2. 02-Jan-19 DBC
3. 02-Jan-19 SAV
4. 03-Jan-19 OFS
5. 03-Jan-19 DBC
6. 03-Jan-19 SAV
,,,,,,,,,,,,,,,,,,,,,,,,

I want to return from the above table by a query as the below:

Rank DDate
1. 02-Jan-19
2. 03-Jan-19
3. 04-Jan-19
,,,,,,,,,,,,
My aim is to use the result for a table called tblTransactions.

How can I achieve solve this issue?

Thanks in advance.


Sent from my HUAWEI NXT-L29 using Tapatalk

 

[Ranman256]

the rank looks a simple ascending date.
(set unique values = true)

select DISTINCT Date from table

 

[plog]

This will require a subquery to first get unique dates:

SELECT DDate FROM deptSeq GROUP BY DDate

Name that 'sub'. Then to rank them use this query based on sub:

SELECT DCount("[DDate]", "sub", "[DDate]<=#" & [DDate] & "#") AS Rank, DDate
FROM sub

 

[Alhakeem1977]

the rank looks a simple ascending date.
(set unique values = true)

select DISTINCT Date from table

Thanks a lot, Ranman255

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[Alhakeem1977]

This will require a subquery to first get unique dates:

SELECT DDate FROM deptSeq GROUP BY DDate

Name that 'sub'. Then to rank them use this query based on sub:

SELECT DCount("[DDate]", "sub", "[DDate]<=#" & [DDate] & "#") AS Rank, DDate
FROM sub

Thank you so much, it works perfect as of my desired.

I have have got an Ms Access database which generates barcode 128 and Code_39 from a vba code.

I would like if it's possible to generates a (2D) QR code from an ofline without internet vba code through a report.

Do you prefer to post it as a new thread?

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[isladogs]

Have a look at this example of a QR generator https://www.access-programmers.co.uk/forums/showpost.php?p=1576752&postcount=1
If that doesn't meet your needs please start a new thread