Query Help- Need one row per Unique Identifier

[KMJG]

Hello All!

I have the following Query (I used the wizard in Excel):
Query.JPG


For each Unique ID there could be multiple rows because the item was requoted, repackaged, or various other things may have happened to this project.

What I want is 1 row for each Unique ID # based on the most recent Cost Date.

Can you help? This query was written using the query wizard in Excel and is linking to an Access Database. I tried using JOIN and I got an error.

Thank you!

[AranDG]

Had this issue a while back and used this post:

http://stackoverflow.com/questions/4...cent-date-item

Haven't tried it using your details but it worked for me, just add your sort and filters

Please Login or Register  to view this content.

[KMJG]

Thank you! I just tried this and am getting an error message:
Query error.JPG
Query 2.JPG

[AranDG]

Looks like you've taken the code literally as it was on the Stack Overflow page, you are requesting results of Unique ID that equal an unassigned value variable. Your query is basically leaving out the other side of the WHERE equation.

Something like this may work, please bear in mind I can't test any of this:

Please Login or Register  to view this content.