Accedi alla query producendo risultati come ROW_NUMBER () in T-SQL

Abbiamo la funzione ROW_NUMBER in MS Access? Se è così, per favore fammi sapere qualsiasi syntax perché sono bloccato qui. Ho provato i forum ma ottengo la syntax del server SQL. Di seguito è la mia domanda:

select ROW_NUMBER() OVER (ORDER BY t.TID) AS uni , t.TSource as [Source], t.TText as [Text], u.Name as [UserId], u.Image_Url as [ImageFilePath], from table1 t inner join table2 u on t.UserId = u.UIds 

ma dà errore di syntax.

In Access SQL a volte è ansible utilizzare un self-join per produrre un ordine di classificazione. Ad esempio, per [table1]

 TID UserId TSource TText --- ------ ------- ----- 412 homer foo bar 503 marge baz thing 777 lisa more stuff 

la query

 SELECT t1a.TID, t1a.UserId, t1a.TSource, t1a.TText, COUNT(*) AS TRank FROM table1 AS t1a INNER JOIN table1 AS t1b ON t1a.TID >= t1b.TID GROUP BY t1a.TID, t1a.UserId, t1a.TSource, t1a.TText 

produce

 TID UserId TSource TText TRank --- ------ ------- ----- ----- 412 homer foo bar 1 503 marge baz thing 2 777 lisa more stuff 3 

e possiamo usarlo come subquery nel nostro JOIN all’altro tavolo

 select t.TRank as uni, t.TSource as [Source], t.TText as [Text], u.Name as [UserId], u.Image_Url as [ImageFilePath] from ( SELECT t1a.TID, t1a.UserId, t1a.TSource, t1a.TText, COUNT(*) AS TRank FROM table1 AS t1a INNER JOIN table1 AS t1b ON t1a.TID >= t1b.TID GROUP BY t1a.TID, t1a.UserId, t1a.TSource, t1a.TText ) AS t INNER JOIN table2 AS u ON t.UserId = u.UIds 

produrre qualcosa di simile

 uni Source Text UserId ImageFilePath --- ------ ----- ------------ ------------- 1 foo bar HomerSimpson whatever1 2 baz thing MargeSimpson whatever2 3 more stuff LisaSimpson whatever3