ACCESS FEED: RE: [MS_AccessPros] filter this year vs. ytd

Rabu, 15 Mei 2013

RE: [MS_AccessPros] filter this year vs. ytd

Thanks Duane, It's 2007 and it is a right click on a datasheet view, and then there is a "date filters" which brings up a second set of options (all this I didn't even know about until my user told me) and at that level there is a this year option as well as a ytd option.

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@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Wednesday, May 15, 2013 11:54 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] filter this year vs. ytd

Liz,
What version of Access?
Are you referring to some type of filter behavior when right clicking a field name in datasheet view? In Access 2010, I don't see "this year" or "ytd".

What does the date "1/13/2013" have to do with anything?

I'm confusioned!

Duane Hookom MVP
MS Access

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: liz_ravenwood@beaerospace.com
> Date: Wed, 15 May 2013 16:20:43 +0000
> Subject: [MS_AccessPros] filter this year vs. ytd
>
> 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

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

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.