[AccessD] Simulating ROW_NUMBER in access

[Ryan W]

I got it... it's ugly but it works.

WHERE outerquery.ID = subquery.id AND  and
CDBL(cdate(subquery.sample_date))+cdbl(cdate(cstr( subquery .sample_time)))
<=
CDBL(cdate(outerquery.sample_date))+cdbl(cdate(cstr(outerquery.sample_time)))

For whatever reason even though sample_date and sample_time are varchar, I
have to cast them to string so I can cast them to a date to convert to a
double.. heh


On Thu, Apr 13, 2023 at 12:10 PM Ryan W <wrwehler at gmail.com> wrote:

> Whoops, I sent the wrong dang fiddle URL:
>
> https://dbfiddle.uk/68MqShXH
>
> The one in the original email is where I made a new date/time field, which
> worked but I can't include that in the exported data, so I'm trying to
> composite the sample_date and sample_time fields to get the right
> ROW_NUMBER (or maybe it's more of a rank/dense rank situation).
>
>
>
>