View Single Post
  #6  
Old June 8th, 2010, 04:13 AM posted to microsoft.public.access.queries
JR[_9_]
external usenet poster
 
Posts: 3
Default complex query to pull unique values

in the query view or sql view?



"John W. Vinson" wrote in message
...
On Mon, 7 Jun 2010 21:41:24 -0400, "JR" wrote:

Same query, except the for the date instead of First, I put Last and it
works.


sheer coincidence and good luck. Use the subquery instead.
--

John W. Vinson [MVP]