G
Guest
HOW I CAN CHANGE THE FIRST DAY OF THE WEEK FOR SATURDAY, BECAUSE SUNDAY COMES
AS PATTERN
AS PATTERN
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Where are you trying to make the change?
VBA functions like DatePart, Weelday and Format allow you to specify the
first day of the week as an argument.
VBA functions like DatePart, Weelday and Format allow you to specify the
first day of the week as an argument.
G
Guest
When I use the assistant to do a report contained for weeks, he returns me
with weeks of Sunday to Saturday, but I want that he does of Friday to
Saturday.
We know that the Default for the first day of the week is Sunday w=1, I want
to change for w=7, however I don't know where to do that.
The easiest possible!
Marco Ruffo
"Douglas J. Steele" escreveu:
with weeks of Sunday to Saturday, but I want that he does of Friday to
Saturday.
We know that the Default for the first day of the week is Sunday w=1, I want
to change for w=7, however I don't know where to do that.
The easiest possible!
Marco Ruffo
"Douglas J. Steele" escreveu:
D
Douglas J. Steele
I'm not sure you can override that behaviour. You might have to add a
computed field to the report's recordsource that returns the Weeknumber the
way you want it (i.e. DatePart("ww", YourDateField, 7)), and group on that.
computed field to the report's recordsource that returns the Weeknumber the
way you want it (i.e. DatePart("ww", YourDateField, 7)), and group on that.
G
Guest
This was not very clear for me. It will be that I could send you for e-mail
this report done by the assistant so that you of that a glance. I Thanks You!!
Marcos Ruffo
"Douglas J. Steele" escreveu:
this report done by the assistant so that you of that a glance. I Thanks You!!
Marcos Ruffo
"Douglas J. Steele" escreveu:
D
Douglas J. Steele
Sorry, I don't accept e-mails for newsgroup topics.
G
Guest
Hi Doug Did what you spoke, I put = PartData ("w"; [it Dates];7), and he got
to change Saturday for the first day, but I don't know how I do now to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
to change Saturday for the first day, but I don't know how I do now to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
D
Douglas J. Steele
I'm assuming that you're currently grouping on [it Dates], and you've set
the Group On property to Week.
I'm suggesting that you group on that computed field instead. Note, though,
that I'd said you needed to use "ww" with the DatePart function. "w" gives
you the day of the week, not the week number.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
the Group On property to Week.
I'm suggesting that you group on that computed field instead. Note, though,
that I'd said you needed to use "ww" with the DatePart function. "w" gives
you the day of the week, not the week number.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:Hi Doug Did what you spoke, I put = PartData ("w"; [it Dates];7), and he
got
to change Saturday for the first day, but I don't know how I do now to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
Sorry, I don't accept e-mails for newsgroup topics.
G
Guest
Excuse me Doug, but I think I still didn't understand what you told me!. When
I use "WW" in the expression, she returns me number of the week, but when I
only use with "w" (Expr1: PartData ("w"; [it Dates];7)) in a consultation she
gets to change the first day of the week for Saturday, however I still don't
know as I can contain this expression, because he returns me the number of
the week and no the name of the day of the week.
Marcos Ruffo
"Douglas J. Steele" escreveu:
I use "WW" in the expression, she returns me number of the week, but when I
only use with "w" (Expr1: PartData ("w"; [it Dates];7)) in a consultation she
gets to change the first day of the week for Saturday, however I still don't
know as I can contain this expression, because he returns me the number of
the week and no the name of the day of the week.
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm assuming that you're currently grouping on [it Dates], and you've set
the Group On property to Week.
I'm suggesting that you group on that computed field instead. Note, though,
that I'd said you needed to use "ww" with the DatePart function. "w" gives
you the day of the week, not the week number.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:Hi Doug Did what you spoke, I put = PartData ("w"; [it Dates];7), and he
got
to change Saturday for the first day, but I don't know how I do now to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
Sorry, I don't accept e-mails for newsgroup topics.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
This was not very clear for me. It will be that I could send you for
this report done by the assistant so that you of that a glance. I
Thanks
You!!
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm not sure you can override that behaviour. You might have to add a
computed field to the report's recordsource that returns the
Weeknumber
the
way you want it (i.e. DatePart("ww", YourDateField, 7)), and group on
that.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
When I use the assistant to do a report contained for weeks, he
returns
me
with weeks of Sunday to Saturday, but I want that he does of Friday
to
Saturday.
We know that the Default for the first day of the week is Sunday
w=1, I
want
to change for w=7, however I don't know where to do that.
The easiest possible!
Marco Ruffo
"Douglas J. Steele" escreveu:
Where are you trying to make the change?
VBA functions like DatePart, Weelday and Format allow you to
specify
the
first day of the week as an argument.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
HOW I CAN CHANGE THE FIRST DAY OF THE WEEK FOR SATURDAY, BECAUSE
SUNDAY
COMES
AS PATTERN
D
Douglas J. Steele
You said that this was in a report, so I assumed you were trying to group by
week.
It's not clear to me now exactly what you're trying to do. The name of the
day of the week doesn't have any bearing on whether the week starts on
Saturday or Sunday.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
week.
It's not clear to me now exactly what you're trying to do. The name of the
day of the week doesn't have any bearing on whether the week starts on
Saturday or Sunday.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:Excuse me Doug, but I think I still didn't understand what you told me!.
When
I use "WW" in the expression, she returns me number of the week, but when
I
only use with "w" (Expr1: PartData ("w"; [it Dates];7)) in a consultation
she
gets to change the first day of the week for Saturday, however I still
don't
know as I can contain this expression, because he returns me the number of
the week and no the name of the day of the week.
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm assuming that you're currently grouping on [it Dates], and you've set
the Group On property to Week.
I'm suggesting that you group on that computed field instead. Note,
though,
that I'd said you needed to use "ww" with the DatePart function. "w"
gives
you the day of the week, not the week number.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:Hi Doug Did what you spoke, I put = PartData ("w"; [it Dates];7), and
he
got
to change Saturday for the first day, but I don't know how I do now to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
Sorry, I don't accept e-mails for newsgroup topics.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
This was not very clear for me. It will be that I could send you for
this report done by the assistant so that you of that a glance. I
Thanks
You!!
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm not sure you can override that behaviour. You might have to add
a
computed field to the report's recordsource that returns the
Weeknumber
the
way you want it (i.e. DatePart("ww", YourDateField, 7)), and group
on
that.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
When I use the assistant to do a report contained for weeks, he
returns
me
with weeks of Sunday to Saturday, but I want that he does of
Friday
to
Saturday.
We know that the Default for the first day of the week is Sunday
w=1, I
want
to change for w=7, however I don't know where to do that.
The easiest possible!
Marco Ruffo
"Douglas J. Steele" escreveu:
Where are you trying to make the change?
VBA functions like DatePart, Weelday and Format allow you to
specify
the
first day of the week as an argument.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
HOW I CAN CHANGE THE FIRST DAY OF THE WEEK FOR SATURDAY,
BECAUSE
SUNDAY
COMES
AS PATTERN
G
Guest
The report that I want is contained by weeks of Saturday for Friday, totaling
the values of that week, as in the example below: There is a table with the
columns
DATE $
07/11/03 500
07/11/04 100
07/11/05 900
07/11/11 500
07/11/12 1000
07/11/13 1000
07/11/17 1000
starting from her want a Saturday report for Friday that should be more or
less like this
07/11/03 ----> 07/11/09 $ 1500
07/11/10 ----> 07/11/16 $ 2500
07/11/17 ----> 07/11/23 $ 1000 ... ... and so on
"Douglas J. Steele" escreveu:
the values of that week, as in the example below: There is a table with the
columns
DATE $
07/11/03 500
07/11/04 100
07/11/05 900
07/11/11 500
07/11/12 1000
07/11/13 1000
07/11/17 1000
starting from her want a Saturday report for Friday that should be more or
less like this
07/11/03 ----> 07/11/09 $ 1500
07/11/10 ----> 07/11/16 $ 2500
07/11/17 ----> 07/11/23 $ 1000 ... ... and so on
"Douglas J. Steele" escreveu:
You said that this was in a report, so I assumed you were trying to group by
week.
It's not clear to me now exactly what you're trying to do. The name of the
day of the week doesn't have any bearing on whether the week starts on
Saturday or Sunday.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:Excuse me Doug, but I think I still didn't understand what you told me!.
When
I use "WW" in the expression, she returns me number of the week, but when
I
only use with "w" (Expr1: PartData ("w"; [it Dates];7)) in a consultation
she
gets to change the first day of the week for Saturday, however I still
don't
know as I can contain this expression, because he returns me the number of
the week and no the name of the day of the week.
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm assuming that you're currently grouping on [it Dates], and you've set
the Group On property to Week.
I'm suggesting that you group on that computed field instead. Note,
though,
that I'd said you needed to use "ww" with the DatePart function. "w"
gives
you the day of the week, not the week number.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
Hi Doug Did what you spoke, I put = PartData ("w"; [it Dates];7), and
he
got
to change Saturday for the first day, but I don't know how I do now to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
Sorry, I don't accept e-mails for newsgroup topics.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
This was not very clear for me. It will be that I could send you for
this report done by the assistant so that you of that a glance. I
Thanks
You!!
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm not sure you can override that behaviour. You might have to add
a
computed field to the report's recordsource that returns the
Weeknumber
the
way you want it (i.e. DatePart("ww", YourDateField, 7)), and group
on
that.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
When I use the assistant to do a report contained for weeks, he
returns
me
with weeks of Sunday to Saturday, but I want that he does of
Friday
to
Saturday.
We know that the Default for the first day of the week is Sunday
w=1, I
want
to change for w=7, however I don't know where to do that.
The easiest possible!
Marco Ruffo
"Douglas J. Steele" escreveu:
Where are you trying to make the change?
VBA functions like DatePart, Weelday and Format allow you to
specify
the
first day of the week as an argument.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
HOW I CAN CHANGE THE FIRST DAY OF THE WEEK FOR SATURDAY,
BECAUSE
SUNDAY
COMES
AS PATTERN
D
Douglas J. Steele
So it does look as though you can group on the calculated week number. The
trick becomes putting the week start and end dates in the group header.
DateAdd("ww", WeekNumber - 1, #2007-01-01#) will give you a date in week.
You can determine the Saturday of that week using DateAdd("ww", WeekNumber -
1, #2007-01-01#) - Weekday(DateAdd("ww", WeekNumber - 1, #2007-01-01#)) and
the Friday of that week as DateAdd("ww", WeekNumber - 1, #2007-01-01#) -
Weekday(DateAdd("ww", WeekNumber - 1, #2007-01-01#)) + 6
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
trick becomes putting the week start and end dates in the group header.
DateAdd("ww", WeekNumber - 1, #2007-01-01#) will give you a date in week.
You can determine the Saturday of that week using DateAdd("ww", WeekNumber -
1, #2007-01-01#) - Weekday(DateAdd("ww", WeekNumber - 1, #2007-01-01#)) and
the Friday of that week as DateAdd("ww", WeekNumber - 1, #2007-01-01#) -
Weekday(DateAdd("ww", WeekNumber - 1, #2007-01-01#)) + 6
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:The report that I want is contained by weeks of Saturday for Friday,
totaling
the values of that week, as in the example below: There is a table with
the
columns
DATE $
07/11/03 500
07/11/04 100
07/11/05 900
07/11/11 500
07/11/12 1000
07/11/13 1000
07/11/17 1000
starting from her want a Saturday report for Friday that should be more or
less like this
07/11/03 ----> 07/11/09 $ 1500
07/11/10 ----> 07/11/16 $ 2500
07/11/17 ----> 07/11/23 $ 1000 ... ... and so on
"Douglas J. Steele" escreveu:
You said that this was in a report, so I assumed you were trying to group
by
week.
It's not clear to me now exactly what you're trying to do. The name of
the
day of the week doesn't have any bearing on whether the week starts on
Saturday or Sunday.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
MRUFFO said:Excuse me Doug, but I think I still didn't understand what you told
me!.
When
I use "WW" in the expression, she returns me number of the week, but
when
I
only use with "w" (Expr1: PartData ("w"; [it Dates];7)) in a
consultation
she
gets to change the first day of the week for Saturday, however I still
don't
know as I can contain this expression, because he returns me the number
of
the week and no the name of the day of the week.
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm assuming that you're currently grouping on [it Dates], and you've
set
the Group On property to Week.
I'm suggesting that you group on that computed field instead. Note,
though,
that I'd said you needed to use "ww" with the DatePart function. "w"
gives
you the day of the week, not the week number.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
Hi Doug Did what you spoke, I put = PartData ("w"; [it Dates];7),
and
he
got
to change Saturday for the first day, but I don't know how I do now
to
contain to leave of that field the weeks in a report.
"Douglas J. Steele" escreveu:
Sorry, I don't accept e-mails for newsgroup topics.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
This was not very clear for me. It will be that I could send you
for
this report done by the assistant so that you of that a glance. I
Thanks
You!!
Marcos Ruffo
"Douglas J. Steele" escreveu:
I'm not sure you can override that behaviour. You might have to
add
a
computed field to the report's recordsource that returns the
Weeknumber
the
way you want it (i.e. DatePart("ww", YourDateField, 7)), and
group
on
that.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
When I use the assistant to do a report contained for weeks,
he
returns
me
with weeks of Sunday to Saturday, but I want that he does of
Friday
to
Saturday.
We know that the Default for the first day of the week is
Sunday
w=1, I
want
to change for w=7, however I don't know where to do that.
The easiest possible!
Marco Ruffo
"Douglas J. Steele" escreveu:
Where are you trying to make the change?
VBA functions like DatePart, Weelday and Format allow you to
specify
the
first day of the week as an argument.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
HOW I CAN CHANGE THE FIRST DAY OF THE WEEK FOR SATURDAY,
BECAUSE
SUNDAY
COMES
AS PATTERN
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.