Access Query - SQL

One Access Query. Currently I run an update query to build an intermediate table, and then join to that table. I want the process to be just one select query. Simple if you know how! ## Deliverables In the attached access database, I run Update Query BuildMarketMaxSeqNo to find the MAX(Seqeuence_Number) for each Market_ID in Table Detail_Price. This builds table MarketMaxSeqNo. I then run Query SelectionsOutput which joins Table MarketMaxSeqNo to restrict the output to that Sequence_No for each Market_ID. I want the query SelectionsOutput re-written so that it does not need the table MarketMaxSeqNo. Output should be the same as current process. I presume this involves a sub-query. I expect the coder to know the answer immediately and should be able deliver within 24 hours. Regards, Pete. * * *This broadcast message was sent to all bidders on Wednesday Oct 6, 2010 4:15:58 PM: Hi, sorry this project was closed well over a year ago - I don't know how it got reposted / reopened?. I will close it (again) now. Peter.