Query for latest date? what am I doing wrong?

[Overdive]

Hello



So I have 2 tables: Metals and Price

I made a query to pull only the records from METAL based on the latest date (using the total button then selecting "Last" from the criteria for all the fields-this was the only way that it will actualy select, if I only use MAX or LAST for the date field it will just pull up all the records from the METAL table which I am not sure why it does that)

I made another query to do the same from the PRICE table, however if I do use MAX or LAST it doesnt match the correct rows, it mixes the rows which is incorrect.

any input of how I can fix it? I researched on many websites and all it said is to use MAX and it should select the appropriate row that has the latest date...

[tingletangle]

Hello,

i would suggest the following: Try to keep the query more simple ! Just select two output fields. the id of the item and the Date field.
Set the on the date the max function.
Does it work now ? If so you can create a second query. Add the first query to that as well as the price table. Link the ID fields and show the fields as required.

bye
Markus