Re: Nearest max date before a specified one
- From: "John Spencer (MVP)" <spencer4@xxxxxxxxxxx>
- Date: Mon, 20 Jun 2005 19:16:39 -0400
Well I thought it was strange to see the R there. It would be valid syntax if
you had a table named "R" but wished to refer to the table in the query as
"tblDates". Normally, you would probably do that the other way round - a table
named tblDates that you wanted to refer to as R to cut down on typing or as a
second instance of the same table in some self-referencing schemes.
Frank wrote:
>
> Hi,
>
> Thank you for the responses. I have noticed in both responses the letter "R"
> after word FROM. What does this do? Thanks.
>
> Frank
>
> "John Spencer (MVP)" <spencer4@xxxxxxxxxxx> wrote in message
> news:42B494CF.1EC27E65@xxxxxxxxxxxxxx
> >
> > SELECT Max(tblDates.dEntryDate) as MaxDate
> > FROM R tblDates
> > WHERE (((tblDates.dEntryDate)<CDate('1.1.2005')));
> >
> > Frank wrote:
> >>
> >> Hi,
> >>
> >> I am trying to create an SQL statement which would return to me the
> >> maximum
> >> date before a specified date. I was able to get a list of records with
> >> dates
> >> prior to the one I enter but not the last one. Can anyone help? Thanks.
> >>
> >> SELECT tblDates.dEntryDate
> >> FROM R tblDates
> >> WHERE (((tblDates.dEntryDate)<CDate('1.1.2005')));
> >>
> >> Frank
.
- References:
- Nearest max date before a specified one
- From: Frank
- Re: Nearest max date before a specified one
- From: John Spencer (MVP)
- Re: Nearest max date before a specified one
- From: Frank
- Nearest max date before a specified one
- Prev by Date: Re: Nearest max date before a specified one
- Next by Date: Re: Expression help - query looks to subform
- Previous by thread: Re: Nearest max date before a specified one
- Next by thread: User to select query columns
- Index(es):
Relevant Pages
|
