query all values equal to the nearest payday??

From: "tlyczko" <tlyczko@xxxxxxxxx>
Date: 27 Oct 2006 12:25:30 -0700

Hi, I have a weird query question. :)

I need to pull out a list of rows according to the most recent payday,
and payday is one of the fields the table.

Because I have to include other fields in the query, using MAX doesn't
solve my problem completely, I get multiple rows for the same max
payday (e.g. 3 rows containing 10/6/2006 payday, 3 rows containing
10/20/2006 payday)..

How can I make the query look into another table containing payday
dates and query for the payday closest to today's date??

So that I only get the 3 rows containing 10/20/2006 payday??

Thank you, Tom

.

Follow-Ups:
- Re: query all values equal to the nearest payday??
  - From: Jeff L

Prev by Date: Re: To Crosstab or not to crosstab
Next by Date: Re: Can I put a comment in SQL code of an Access Query, how?
Previous by thread: To Crosstab or not to crosstab
Next by thread: Re: query all values equal to the nearest payday??
Index(es):
- Date
- Thread

Relevant Pages

Re: query all values equal to the nearest payday??
... I am now looking at datediff type functions because that would enable ... most recent payday's data, regardless of the actual payday date...makes ... Finally this query has to be converted/compatible to SQL Server 2005 ... tlyczko wrote: ...
(microsoft.public.access.queries)
Re: query all values equal to the nearest payday??
... From TblPaydayDates Where Payday < Date) ... tlyczko wrote: ... I need to pull out a list of rows according to the most recent payday, ... Because I have to include other fields in the query, ...
(microsoft.public.access.queries)