Get the last dataset (1 Viewer)

[georg7]

Hi there,
I've a db with table(Tabelle2 mitarbeiter) for all employees and a table(Tabelle1 tname) to save who worked together. Now I want to create a querry that shows only the last dataset. I tried it with Max(ID) and Last(ID). Hopefully someone can help.

Best regards
Georg

 

[arnelgp]

you need 2 queries:

1st query (qryMaxID):

SELECT Max(Tabelle1.ID) AS MaxOfID
FROM Tabelle1;


2nd query (qryLastWorkedTogether):

SELECT Tabelle1.ID, Tabelle1.tname.Value, Tabelle1.tname
FROM Tabelle1 INNER JOIN qryMaxID ON Tabelle1.ID = qryMaxID.MaxOfID;

 

[georg7]

Thank you @arnelgp it worked ! Do you know how I get a report that Displays the last query? The report don't Shows the single names like in the query..

 

[arnelgp]

its a Multivalue field so you have to create a function to
retrieve the Names.

see the report and the code in it.

 

[georg7]

Thank you @arnelgp ! Top work as always!!! Have a nice Weekend