Search results

Yes, vbaInet, the intent was just that - one column with all dates except min and the other column with all dates except max. I know that it seems kind of strange, but that is what I need to achieve. Thanks for your help.

The desired output is: Yellow Blue 11/23/2013 11/19/2013 11/19/2013 10/01/2012 10/01/2102 10/08/2010 10/08/2010...

Here it is the citizens table: Name BirthDate DeathDate Jerry Smith 12/14/2007 11/19/2013 John Johnson 10/08/2010 11/23/2013 Will Williams 10/01/2012 Sandy Sanders...

Thanks. I have tested all of the sub-queries and they all work. If I switch the short_list and long_list the problem follows the move - the sub-query on the right of the FROM only gets 1 record. It may very well be the Cartesian Product issue. I tried using the joins, but they produced the...

I have SQL query/dual sub-query in MS Access that is returning data from the left side of the query FROM correctly, but is only returning one record from the right side of the query FROM. Furthermore, it repeats the display of the one record and it repeats the entire results set with a different...