Find how many items in table, with column DateAdded is the latest DateAdded in that column
Converting that column from DateTime to Date so we can find count per day
For each Year.
SQL worked for db.xlsx (Access mdb usually)
Find how many items in table, with column DateAdded is the latest DateAdded in that column
Converting that column from DateTime to Date so we can find count per day
For each Year
Allow developer to have output to user as ...
16 Legsh(s) added Tuesday, October 24, 2023
After getting the count and the date for that count.
SQL worked for db.xlsx (Access mdb usually)
This is SQL template, means developer needs to replace {$Year$} with proper condition before running.
sQUpdates = "Select Count(*) as Coco, DateValue([DateAdded]) As DateAdded From [Legsh$] Where Year = '{$Year$}' And " & _
"DateValue([DateAdded]) = (Select Top 1 DateValue([DateAdded]) from [Legsh$] Where Year = '{$Year$}' Order By [DateAdded] Desc, FileName Asc) " & _
"Group by DateValue([DateAdded]); "
Converting that column from DateTime to Date so we can find count per day
For each Year
Allow developer to have output to user as ...
16 Legsh(s) added Tuesday, October 24, 2023
After getting the count and the date for that count.
SQL worked for db.xlsx (Access mdb usually)
This is SQL template, means developer needs to replace {$Year$} with proper condition before running.
sQUpdates = "Select Count(*) as Coco, DateValue([DateAdded]) As DateAdded From [Legsh$] Where Year = '{$Year$}' And " & _
"DateValue([DateAdded]) = (Select Top 1 DateValue([DateAdded]) from [Legsh$] Where Year = '{$Year$}' Order By [DateAdded] Desc, FileName Asc) " & _
"Group by DateValue([DateAdded]); "
Views 142
Downloads 54
CodeID
DB ID