W
wclairmont
Could anyone let me know if there is an update to fix the Office 2007 problem
with the 2008 leap year?
Thanks!
with the 2008 leap year?
Thanks!
M
Milly Staples [MVP - Outlook]
What problem?
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.
After furious head scratching, wclairmont asked:
| Could anyone let me know if there is an update to fix the Office 2007
| problem with the 2008 leap year?
|
| Thanks!
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.
After furious head scratching, wclairmont asked:
| Could anyone let me know if there is an update to fix the Office 2007
| problem with the 2008 leap year?
|
| Thanks!
T
TaurArian
http://blogs.msdn.com/inside_office...ice-2007-service-pack-1-coming-next-week.aspx
--
====================================
TaurArian [MVP] 2005-2008 - Australia
====================================
How to ask a question: http://support.microsoft.com/kb/555375
http://taurarian.mvps.org/index.htm
Emails will not be acknowledged - please post to the newsgroup so all may benefit.
| Could anyone let me know if there is an update to fix the Office 2007 problem
| with the 2008 leap year?
|
| Thanks!
--
====================================
TaurArian [MVP] 2005-2008 - Australia
====================================
How to ask a question: http://support.microsoft.com/kb/555375
http://taurarian.mvps.org/index.htm
Emails will not be acknowledged - please post to the newsgroup so all may benefit.
| Could anyone let me know if there is an update to fix the Office 2007 problem
| with the 2008 leap year?
|
| Thanks!
M
Millicent
I have Office 2007 Sp 1 installed.
When I attempt to create a report based on a query which has the following
code:
Between [Forms]![frmMonthlySelector]![StartDate] And
[Forms]![frmMonthlySelector]![EndDate]
where [StartDate] and [EndDate] are fields in the form frmMonthlySelector;
For dates between 1/1/08 and 1/31/08 I get a full report including items
that have a date of 1/31/08.
However, when I enter dates between 2/1/08 and 2/29/08 the report shows
dates only from 2/1/08 and 2/28/08 and leaves off 2/29/08.
As a test I entered static values, ie:
Between #2/1/08# And #2/29/08#j
The report once again left off any items with a date of 2/29/08.
When I attempt to create a report based on a query which has the following
code:
Between [Forms]![frmMonthlySelector]![StartDate] And
[Forms]![frmMonthlySelector]![EndDate]
where [StartDate] and [EndDate] are fields in the form frmMonthlySelector;
For dates between 1/1/08 and 1/31/08 I get a full report including items
that have a date of 1/31/08.
However, when I enter dates between 2/1/08 and 2/29/08 the report shows
dates only from 2/1/08 and 2/28/08 and leaves off 2/29/08.
As a test I entered static values, ie:
Between #2/1/08# And #2/29/08#j
The report once again left off any items with a date of 2/29/08.
B
Bob Buckland ?:-\)
Hi Millicent,
I'm assuming this is in Access 2007? If so, you may want to use the link below to also post in the MS Office Access discussion
group on this.
==============
I have Office 2007 Sp 1 installed.
When I attempt to create a report based on a query which has the following
code:
Between [Forms]![frmMonthlySelector]![StartDate] And
[Forms]![frmMonthlySelector]![EndDate]
where [StartDate] and [EndDate] are fields in the form frmMonthlySelector;
For dates between 1/1/08 and 1/31/08 I get a full report including items
that have a date of 1/31/08.
However, when I enter dates between 2/1/08 and 2/29/08 the report shows
dates only from 2/1/08 and 2/28/08 and leaves off 2/29/08.
As a test I entered static values, ie:
Between #2/1/08# And #2/29/08#j
The report once again left off any items with a date of 2/29/08. >>
--
Please let us know if this has helped,
Bob Buckland ?
MS Office System Products MVP
LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
I'm assuming this is in Access 2007? If so, you may want to use the link below to also post in the MS Office Access discussion
group on this.
==============
I have Office 2007 Sp 1 installed.
When I attempt to create a report based on a query which has the following
code:
Between [Forms]![frmMonthlySelector]![StartDate] And
[Forms]![frmMonthlySelector]![EndDate]
where [StartDate] and [EndDate] are fields in the form frmMonthlySelector;
For dates between 1/1/08 and 1/31/08 I get a full report including items
that have a date of 1/31/08.
However, when I enter dates between 2/1/08 and 2/29/08 the report shows
dates only from 2/1/08 and 2/28/08 and leaves off 2/29/08.
As a test I entered static values, ie:
Between #2/1/08# And #2/29/08#j
The report once again left off any items with a date of 2/29/08. >>
--
Please let us know if this has helped,
Bob Buckland ?
MS Office System Products MVP
LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com