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.