Re: Nearest max date before a specified one

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


.

Relevant Pages

  • Re: Nearest max date before a specified one
    ... you had a table named "R" but wished to refer to the table in the query as ... named tblDates that you wanted to refer to as R to cut down on typing or as a ... Frank wrote: ... I have noticed in both responses the letter "R" ...
    (microsoft.public.access.queries)
  • Re: Is there a Compatible Inks review anywhere?
    ... > Frank wrote: ... Your responses don't have ... > DOES HE MANAGER TO RESPOND AND KNOW WHAT I SAY. ... HE IS A LYING MOTHER ...
    (comp.periphs.printers)
  • RE: Survey
    ... I have the same problem as Frank. ... Report will only group up to a certain number. ... don't know how you can group by responses when it is not a field. ... ton of count query for each questions. ...
    (microsoft.public.access.gettingstarted)
  • Re: Nearest max date before a specified one
    ... MS Access MVP ... I have noticed in both responses the letter ... >> Frank wrote: ... >>> FROM R tblDates ...
    (microsoft.public.access.queries)
  • Re: Great deal, great product.
    ... I'm responding to your posts not "spending most of my efforts in ASA ... individuals here frequently post responses to you. ... Robert started flooding the Newsgroup ... Oh, and by the way, I don't look anything like the other Frank. ...
    (alt.security.alarms)