Bar raph with Line Graph

[Guest]

I was curious if you would be able to assist with this. I use a graph and
would like to do 2 things if at all possible.
1 - For the year 2006 I would like to have a bar chart!
2 - For the year of 2005 I would like to have a line chart combined with the
above for referance.

Is this possible?

Here is my coding for the query.

SELECT
[DA Photo].Date,
[DA Photo].Scheduled,
[DA Photo].Cancelled,
[DA Photo].[No Shows],
[DA Photo].Arrived,
[DA Photo].[Standbys Seen],
[DA Photo].[Promotion Boards],
[DA Photo].[Special Packets],
[DA Photo].[Command Required],
[DA Photo].[Field Photos],
[DA Photo].[4 x 6 Prints],
[DA Photo].[8 x 10 Prints],
[DA Photo].[Digital CD's],
[DA Photo].[Images to DAPMIS],
[DA Photo].[Active Army],
[DA Photo].[USAR / NG],
[DA Photo].[General Officers],
[DA Photo].[Other Services],
[DA Photo].Favorable,
[DA Photo].Unfavorable
FROM [DA Photo]
WHERE ((([DA Photo].Date) Between #1/1/2005# And #3/31/2006#));

 

[Duane Hookom]

Do we know if there is one point per "field" where all dates are summed for
the year? What do you want for X and Y axis values?

You can get an Access graph to show one series as a bar and the other series
as a line.