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...