Prev: rere
Next: Entering measurements in a field
From: Clif McIrvin on 5 Apr 2010 20:06
Thanks, Karl. You've supplied yet another approach to the problem. It's
great having you folks to bounce ideas around with!

Clif

"KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message
news:90EF3C62-9778-462E-90CB-28D1DA90AC57(a)microsoft.com...
> Try these two queries --
> qryMaxWeek --
> SELECT Max(AssignedLots.WeekEnding) AS MaxOfWeekEnding
> FROM AssignedLots;
>
> SELECT [Mix Designs].[Mix ID], AssignedLots.LotNo,
> AssignedLots.WeekEnding
> FROM [Mix Designs] INNER JOIN AssignedLots ON [Mix Designs].MixID =
> AssignedLots.MixID, qryMaxWeek
> WHERE (((AssignedLots.WeekEnding)=[MaxOfWeekEnding])) OR
> (((AssignedLots.WeekEnding)>DateAdd("d",-14,[MaxOfWeekEnding])));
>
>
> AssignedLots.WeekEnding
>
> --
> Build a little, test a little.
>
>
>


First  |  Prev  | 
Pages: 1 2 3 4
Prev: rere
Next: Entering measurements in a field