Rabu, 15 Mei 2013

RE: [MS_AccessPros] Re: filter this year vs. ytd

 

Graham-

No website. I've forwarded the entire string to my contact in MS Access
support.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
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 Graham Mandeno
Sent: Wednesday, May 15, 2013 8:39 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: filter this year vs. ytd

The mystery becomes clear if you apply the YTD filter and then go to
Advanced Filter/Sort to examine the result.

Some not-very-clever person has implemented this filter for YTD:

Year([DateField]) = Year(Date()) AND
Month([DateField]) <= Month(Date()) AND
Day([DateField]) <= Day(Date())

This will exclude any records from past months where the day number is past
the current day in this month. on June 1 you will only get records for 6
days!!!

Of course, the filter should be:

Year([DateField]) = Year(Date()) AND [DateField] <= Date()

Definitely a bug - thanks for reporting it, John. Do you have a URL to
reference it so we can all go there and vote? I understand this has some
bearing on how seriously it is taken.

Cheers,
Graham

--- Bill Mosca wrote:
 
Liz

I just tested and came up with weird results, too. In my table I have 62
records for 2013. When I use This Year as the filter, I get all 63. When I
use Year To Date I get 27. I can't see any kind of pattern as to which ones
are excluded. It seems random. I even sorted the dates to see if the first
27 in the bigger set was the same, but they are not.

Looks like a bug to me!

Bill Mosca.

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood
<liz_ravenwood@...> wrote:
>
> Pros, It's another weird day in paradise.
>
> I've never done this, but a user showed me and I'm having the same
experience. Right click on a date field and she says this year - it gives
her 8437. Right click on the same field and say ytd, and it gives 4934. I
even did a clear filters before I tried it and I get the same thing.
>
> An unmatched shows a record that clearly has the date 1/13/2013. I
> didn't
check any others... (is it cause 13 is unlucky? ;-) )
>
> Weird!
>
> Respectfully,
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com<http://www.beaerospace.com>
>
> This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail
and destroy all copies of the original message.
>
>
> [Non-text portions of this message have been removed]
>

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

Yahoo! Groups Links

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar