Max Date Query Not Working

T

TJAC

I posted earlier with a question about how I can pull the maximum date from
a table that contains several records for the same vendor. If I just use
Max, it won't work because there are several ratings as well.

I used this query based on the link I was given...
SELECT VendorAddress.VendorName, VendorAddress.AKA,
VendorAddress.StreetAddress, VendorAddress.POBox, VendorAddress.Country,
VendorAddress.City, VendorAddress.State, VendorAddress.Zip,
VendorAddress.Phone1, VendorAddress.Phone2, VendorAddress.Fax,
VendorAddress.WebAddress, VendorAddress.Comments, VendorRatings.Rating,
VendorRatings.DateChange
FROM VendorAddress INNER JOIN VendorRatings ON VendorAddress.VendorName =
VendorRatings.VendorName
Having (((VendorRatings.DateChange)=Max([VendorRatings].[DateChange])));

However, I can't get it to work. Can someone please tell me what I have
done wrong?

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return fields associated with max value record 9
Query/Iff/Max not working right 1
Min and Max for Date Range in Report 4
Hide dupes in a query 3
Max query doesn't return the Max value for a field?! 2
can't find the right query 0
Using Max or DMax in DLookUp criteria? 1
query most recent date 1

Top