Chart monthly...Help Needed Please....

[Guest]

I have chart ..it will give me monthly sales details....X axis is
Dates...like 1.2.3....31
Y axis is Amounts....dynamic chart...i use only one chart for all 12 months..

if i have sales ..only for 14 days...in chart i would like to see the line
upto 14..
and number of days should be there like 30 or 31 depends upon the month.
but now i see the chart shows 1.2.3....14 and sales line goes upto end of
the chart.
i would like to see in chart ...all the days..but the line should stop at
14th day.

Thanks in Advance.

 

[Duane Hookom]

Modify the Row Source of the chart control to return the data like you want
in your chart.

 

[Guest]

Thanks for ur reply......

this is my Row source.....

SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

for example i dont have data for upto 31st July...i have data only 14 days...
but i like to show numbers upto 31 in row...but line should stop at 14...
Please if u give me more details ...really helpful...to me...

Regards

 

[Guest]

could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my like to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in query...Please..

 

[Duane Hookom]

You might want to have a table of all dates that you can use in your row
source query. Join the date fields with a join that includes all the dates
from your table of all dates.

--
Duane Hookom
MS Access MVP

could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my like
to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in query...Please..

Modify the Row Source of the chart control to return the data like you
want
in your chart.

 

[Guest]

Please Please.......i see the monthly chart for all months..of 2003,
2004,2005...etc
i feel practically difficult to have separate table which has dates of all
months of all years.....please reply.....

Regards

You might want to have a table of all dates that you can use in your row
source query. Join the date fields with a join that includes all the dates
from your table of all dates.

--
Duane Hookom
MS Access MVP

could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my like
to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in query...Please..

Modify the Row Source of the chart control to return the data like you
want
in your chart.

--
Duane Hookom
MS Access MVP
--

I have chart ..it will give me monthly sales details....X axis is
Dates...like 1.2.3....31
Y axis is Amounts....dynamic chart...i use only one chart for all 12
months..

if i have sales ..only for 14 days...in chart i would like to see the
line
upto 14..
and number of days should be there like 30 or 31 depends upon the
month.
but now i see the chart shows 1.2.3....14 and sales line goes upto end
of
the chart.
i would like to see in chart ...all the days..but the line should stop
at
14th day.

Thanks in Advance.

 

[Duane Hookom]

Creating a table of all dates isn't that difficult. If you want to use a
table with only 10 records:
Create a table "tblOneToNine" with a single field "Num" of numeric data
type.
Enter in values 0, 1, 2, 3, ...9
Create a query with sql of:

SELECT Date()-
([tblOneToNine].[Num]*1000+
[tblOneToNine_1].[Num]*100+
[tblOneToNine_2].[Num]*10+
[tblOneToNine_3].[Num]) AS AllDates
FROM tblOneToNine,
tblOneToNine AS tblOneToNine_1,
tblOneToNine AS tblOneToNine_2,
tblOneToNine AS tblOneToNine_3;

You can save this query which will result in all dates from 9999 days ago to
today.

--
Duane Hookom
MS Access MVP

Please Please.......i see the monthly chart for all months..of 2003,
2004,2005...etc
i feel practically difficult to have separate table which has dates of all
months of all years.....please reply.....

Regards

You might want to have a table of all dates that you can use in your row
source query. Join the date fields with a join that includes all the
dates
from your table of all dates.

--
Duane Hookom
MS Access MVP

could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my
like
to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in
query...Please..



:

Modify the Row Source of the chart control to return the data like you
want
in your chart.

--
Duane Hookom
MS Access MVP
--

I have chart ..it will give me monthly sales details....X axis is
Dates...like 1.2.3....31
Y axis is Amounts....dynamic chart...i use only one chart for all
12
months..

if i have sales ..only for 14 days...in chart i would like to see
the
line
upto 14..
and number of days should be there like 30 or 31 depends upon the
month.
but now i see the chart shows 1.2.3....14 and sales line goes upto
end
of
the chart.
i would like to see in chart ...all the days..but the line should
stop
at
14th day.

Thanks in Advance.

 

[Guest]

O..Very interesting your Query...really useful....not only for my present
problem...

but i am sorry to ask too much from u......

now i have my query which gives me data(upto 14 days,total sales amount)
and ur query which qives me..all the dates...could u please give me some help
how can i make query..which gives me all the dates in month..but total sales
amount
will be upto 14 days...i mean remaining 16 days i will have empty..in total
sales amount field......


thanks

Creating a table of all dates isn't that difficult. If you want to use a
table with only 10 records:
Create a table "tblOneToNine" with a single field "Num" of numeric data
type.
Enter in values 0, 1, 2, 3, ...9
Create a query with sql of:

SELECT Date()-
([tblOneToNine].[Num]*1000+
[tblOneToNine_1].[Num]*100+
[tblOneToNine_2].[Num]*10+
[tblOneToNine_3].[Num]) AS AllDates
FROM tblOneToNine,
tblOneToNine AS tblOneToNine_1,
tblOneToNine AS tblOneToNine_2,
tblOneToNine AS tblOneToNine_3;

You can save this query which will result in all dates from 9999 days ago to
today.

--
Duane Hookom
MS Access MVP

Please Please.......i see the monthly chart for all months..of 2003,
2004,2005...etc
i feel practically difficult to have separate table which has dates of all
months of all years.....please reply.....

Regards

You might want to have a table of all dates that you can use in your row
source query. Join the date fields with a join that includes all the
dates
from your table of all dates.

--
Duane Hookom
MS Access MVP



could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my
like
to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in
query...Please..



:

Modify the Row Source of the chart control to return the data like you
want
in your chart.

--
Duane Hookom
MS Access MVP
--

I have chart ..it will give me monthly sales details....X axis is
Dates...like 1.2.3....31
Y axis is Amounts....dynamic chart...i use only one chart for all
12
months..

if i have sales ..only for 14 days...in chart i would like to see
the
line
upto 14..
and number of days should be there like 30 or 31 depends upon the
month.
but now i see the chart shows 1.2.3....14 and sales line goes upto
end
of
the chart.
i would like to see in chart ...all the days..but the line should
stop
at
14th day.

Thanks in Advance.

 

[Duane Hookom]

Set the join property to include all the records from your recordset of all
dates. Set the criteria under the AllDates field to limit the dates to your
desired output.

--
Duane Hookom
MS Access MVP
--

O..Very interesting your Query...really useful....not only for my present
problem...

but i am sorry to ask too much from u......

now i have my query which gives me data(upto 14 days,total sales amount)
and ur query which qives me..all the dates...could u please give me some
help
how can i make query..which gives me all the dates in month..but total
sales
amount
will be upto 14 days...i mean remaining 16 days i will have empty..in
total
sales amount field......


thanks

Creating a table of all dates isn't that difficult. If you want to use a
table with only 10 records:
Create a table "tblOneToNine" with a single field "Num" of numeric data
type.
Enter in values 0, 1, 2, 3, ...9
Create a query with sql of:

SELECT Date()-
([tblOneToNine].[Num]*1000+
[tblOneToNine_1].[Num]*100+
[tblOneToNine_2].[Num]*10+
[tblOneToNine_3].[Num]) AS AllDates
FROM tblOneToNine,
tblOneToNine AS tblOneToNine_1,
tblOneToNine AS tblOneToNine_2,
tblOneToNine AS tblOneToNine_3;

You can save this query which will result in all dates from 9999 days ago
to
today.

--
Duane Hookom
MS Access MVP

Please Please.......i see the monthly chart for all months..of 2003,
2004,2005...etc
i feel practically difficult to have separate table which has dates of
all
months of all years.....please reply.....

Regards

:

You might want to have a table of all dates that you can use in your
row
source query. Join the date fields with a join that includes all the
dates
from your table of all dates.

--
Duane Hookom
MS Access MVP



could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my
like
to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in
query...Please..



:

Modify the Row Source of the chart control to return the data like
you
want
in your chart.

--
Duane Hookom
MS Access MVP
--

I have chart ..it will give me monthly sales details....X axis is
Dates...like 1.2.3....31
Y axis is Amounts....dynamic chart...i use only one chart for
all
12
months..

if i have sales ..only for 14 days...in chart i would like to see
the
line
upto 14..
and number of days should be there like 30 or 31 depends upon the
month.
but now i see the chart shows 1.2.3....14 and sales line goes
upto
end
of
the chart.
i would like to see in chart ...all the days..but the line
should
stop
at
14th day.

Thanks in Advance.

 

[Guest]

Dear Duane Hookom ..yes it is working.....i should thank you...
so...Thank you very much.....

Regards
Ismail

Set the join property to include all the records from your recordset of all
dates. Set the criteria under the AllDates field to limit the dates to your
desired output.

--
Duane Hookom
MS Access MVP
--

O..Very interesting your Query...really useful....not only for my present
problem...

but i am sorry to ask too much from u......

now i have my query which gives me data(upto 14 days,total sales amount)
and ur query which qives me..all the dates...could u please give me some
help
how can i make query..which gives me all the dates in month..but total
sales
amount
will be upto 14 days...i mean remaining 16 days i will have empty..in
total
sales amount field......


thanks

Creating a table of all dates isn't that difficult. If you want to use a
table with only 10 records:
Create a table "tblOneToNine" with a single field "Num" of numeric data
type.
Enter in values 0, 1, 2, 3, ...9
Create a query with sql of:

SELECT Date()-
([tblOneToNine].[Num]*1000+
[tblOneToNine_1].[Num]*100+
[tblOneToNine_2].[Num]*10+
[tblOneToNine_3].[Num]) AS AllDates
FROM tblOneToNine,
tblOneToNine AS tblOneToNine_1,
tblOneToNine AS tblOneToNine_2,
tblOneToNine AS tblOneToNine_3;

You can save this query which will result in all dates from 9999 days ago
to
today.

--
Duane Hookom
MS Access MVP


Please Please.......i see the monthly chart for all months..of 2003,
2004,2005...etc
i feel practically difficult to have separate table which has dates of
all
months of all years.....please reply.....

Regards

:

You might want to have a table of all dates that you can use in your
row
source query. Join the date fields with a join that includes all the
dates
from your table of all dates.

--
Duane Hookom
MS Access MVP



could u please have look into this problem again...
my row source is
SELECT (Format([dateofS],"Short Date")) AS Expr1,
Sum(chart2_act_petQ.petrol) AS SumOfpetrol
FROM chart2_act_petQ
GROUP BY (Format([dateofS],"Short Date"));

and if i have sales data only upto 14 days...in the table..but in my
like
to
see numbers upto 30 or 31 or 28 depends upon the current month...
could u please explain me in more details..what to do in
query...Please..



:

Modify the Row Source of the chart control to return the data like
you
want
in your chart.

--
Duane Hookom
MS Access MVP
--

I have chart ..it will give me monthly sales details....X axis is
Dates...like 1.2.3....31
Y axis is Amounts....dynamic chart...i use only one chart for
all
12
months..

if i have sales ..only for 14 days...in chart i would like to see
the
line
upto 14..
and number of days should be there like 30 or 31 depends upon the
month.
but now i see the chart shows 1.2.3....14 and sales line goes
upto
end
of
the chart.
i would like to see in chart ...all the days..but the line
should
stop
at
14th day.

Thanks in Advance.