View Single Post
  #2  
Old June 7th, 2010, 03:29 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default complex query to pull unique values

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]