ACCESS FEED: RE: [MS_AccessPros] Code does not find dates as expected.

Rabu, 27 Juli 2011

RE: [MS_AccessPros] Code does not find dates as expected.

Robin-

Any clue what it doesn't like? I'm not using any functions that you weren't
using previously.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Wednesday, July 27, 2011 1:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Code does not find dates as expected.

That comment was as a result of testing the SQL in Access. The code
generator does not accept this alternative. Is there another way to
get the same result?

Thanks,

Robin Chapple

At 27/07/2011 07:23 PM, you wrote:

>Thanks again John,
>
>That is just what the doctor ordered. I still have my version 2
>manuals and I have found the function and will add it to my list to study.
>
>Regards,
>
>Robin Chapple
>
>
>At 27/07/2011 05:53 PM, you wrote:
> >Robin-
> >
> >WHERE RecordDate BETWEEN DateSerial(Year(Date()), 7, 1) And
> >DateSerial(Year(Date())+1, 6, 30)
> >
> >John Viescas, author
> >Microsoft Office Access 2010 Inside Out
> >Microsoft Office Access 2007 Inside Out
> >Building Microsoft Access Applications
> >Microsoft Office Access 2003 Inside Out
> >SQL Queries for Mere Mortals
> >http://www.viescas.com/
> >(Paris, France)
> >
> >
> >-----Original Message-----
> >From: MS_Access_Professionals@yahoogroups.com
> >[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> >Sent: Wednesday, July 27, 2011 9:29 AM
> >To: MS_Access_Professionals@yahoogroups.com
> >Subject: [MS_AccessPros] Code does not find dates as expected.
> >
> >
> >My organisation has a year which starts on July 1st. I have been
> >using this code:
> >
> >IIf(Month(Date())>=7,DateSerial(Year(Date()),7,1),DateSerial(Year(D
> ate())-1,7,1)
> >)
> >
> >to decide if an entry is "This Organisational Year". The original
> >need was to identify post holders in the year, and appointments are
> >from 1st July.
> >
> >I have recently applied it to a table where the day part of the date
> >is variable and when the date is not 1st and the month is not July
> >and records are missed.
> >
> >How do I edit the code to include any date between 1st July, this
> >year up to 31st December and from 1st January to 30th June in the next year?
> >
> >I have no idea!
> >
> >Many thanks,
> >
> >Robin Chapple
> >
> >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

------------------------------------

Yahoo! Groups Links