Thanks, John.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Wednesday, May 15, 2013 4:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: filter this year vs. ytd
Liz-
I just did.
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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
Sent: Wednesday, May 15, 2013 5:45 PM
To: 'MS_Access_Professionals@yahoogroups.com
<mailto:%26%2339%3BMS_Access_Professionals%40yahoogroups.com> '
Subject: RE: [MS_AccessPros] Re: filter this year vs. ytd
Bill, So who reports these bugs to Microsoft?
Respectfully,
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Wednesday, May 15, 2013 2:11 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Re: filter this year vs. ytd
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
<mailto:MS_Access_Professionals%40yahoogroups.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
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.
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (11) |
Tidak ada komentar:
Posting Komentar