K
Krish
How to make the query to group Sales figures by week starting from Sunday to
Saturday for a date range like 10/03/2004-10/30/2004?
Saturday for a date range like 10/03/2004-10/30/2004?
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
Duane Hookom
Do you have any table and field names?
K
Krish
I am using the expression Date:Format([m_date],"ww") in Crosstab query to
group Sales amount. Crosstab query displays week numbers as 1,2,3,4 etc. I
want the grouping to be done by week starting from Sunday thru Saturday. Can
I accomplish?
Thanks
group Sales amount. Crosstab query displays week numbers as 1,2,3,4 etc. I
want the grouping to be done by week starting from Sunday thru Saturday. Can
I accomplish?
Thanks
K
Krish
Addendum:
I am interested in knowing how to handle Sunday to Saturday overlapping
between two years? 12/26/2004-01/01/2005
I am interested in knowing how to handle Sunday to Saturday overlapping
between two years? 12/26/2004-01/01/2005
Krish said:I am using the expression Date:Format([m_date],"ww") in Crosstab query to
group Sales amount. Crosstab query displays week numbers as 1,2,3,4 etc. I
want the grouping to be done by week starting from Sunday thru Saturday. Can
I accomplish?
Thanks
SundayKrish said:How to make the query to group Sales figures by week starting fromto
Saturday for a date range like 10/03/2004-10/30/2004?
D
Duane Hookom
The expression you are using should group your dates by weeks from Sunday -
Saturday. Is there a reason you are questioning this?
How do you want to handle overlapping two years? Do you want two separate
columns for the year?
--
Duane Hookom
MS Access MVP
Saturday. Is there a reason you are questioning this?
How do you want to handle overlapping two years? Do you want two separate
columns for the year?
--
Duane Hookom
MS Access MVP
Krish said:Addendum:
I am interested in knowing how to handle Sunday to Saturday overlapping
between two years? 12/26/2004-01/01/2005
Krish said:I am using the expression Date:Format([m_date],"ww") in Crosstab query to
group Sales amount. Crosstab query displays week numbers as 1,2,3,4 etc. I
want the grouping to be done by week starting from Sunday thru Saturday. Can
I accomplish?
Thanks
SundayKrish said:How to make the query to group Sales figures by week starting fromto
Saturday for a date range like 10/03/2004-10/30/2004?
K
Krish
The reason I am questioning is, what if I want to group from Monday -Sunday
instead of Sunday-Saturday.
Can Access show week 53, when overlapping two years?
instead of Sunday-Saturday.
Can Access show week 53, when overlapping two years?
Duane Hookom said:The expression you are using should group your dates by weeks from Sunday -
Saturday. Is there a reason you are questioning this?
How do you want to handle overlapping two years? Do you want two separate
columns for the year?
--
Duane Hookom
MS Access MVP
etc.Krish said:Addendum:
I am interested in knowing how to handle Sunday to Saturday overlapping
between two years? 12/26/2004-01/01/2005
Krish said:I am using the expression Date:Format([m_date],"ww") in Crosstab query to
group Sales amount. Crosstab query displays week numbers as 1,2,3,4I Saturday.
Can
D
Duane Hookom
Open a module and then search Access Help on "Format function".
It is very possible for the week to return 53.
--
Duane Hookom
MS Access MVP
--
It is very possible for the week to return 53.
--
Duane Hookom
MS Access MVP
--
Krish said:The reason I am questioning is, what if I want to group from Monday -Sunday
instead of Sunday-Saturday.
Can Access show week 53, when overlapping two years?
Duane Hookom said:The expression you are using should group your dates by weeks from Sunday -
Saturday. Is there a reason you are questioning this?
How do you want to handle overlapping two years? Do you want two separate
columns for the year?
--
Duane Hookom
MS Access MVP
queryKrish said:Addendum:
I am interested in knowing how to handle Sunday to Saturday overlapping
between two years? 12/26/2004-01/01/2005
I am using the expression Date:Format([m_date],"ww") in Crosstab
toetc.group Sales amount. Crosstab query displays week numbers as 1,2,3,4I
want the grouping to be done by week starting from Sunday thru Saturday.
Can
I accomplish?
Thanks
How to make the query to group Sales figures by week starting from
Sunday
to
Saturday for a date range like 10/03/2004-10/30/2004?