RE: Charts / Queries

The first task is to create a form with a couple text boxes for you to enter
the beginning and ending dates. Then create a query that groups by Year and
Month and calculates some value.

Then use the report chart wizard based on the query. The Row Source of the
chart control is the key to what displays in your chart.
--
Duane Hookom
Microsoft Access MVP


"Erik" wrote:

I am trying to create my first chart in a report. I would like to know how to
set the data in the x axis to show the month-year example Jan-07. I would
like it to ask when to start the first month and the last month and then put
it in order of the month and year. I don't know if this makes sense. If not
maybe i can try to explain it a different way. Thanks for any help.
.

Relevant Pages

  • RE: Charts / Queries
    ... Create your form with text boxes and provide us with the names like: ... query to count the number of records that fall in that month. ... "Duane Hookom" wrote: ... Then use the report chart wizard based on the query. ...
    (microsoft.public.access.reports)
  • Re: Use Select Query variable against a table and return value to same select query
    ... > I have a query that calculates how many bottles are sold say 12 ... and the SQL created so far? ... MyTableOneID AUTOINCREMENT PK ... continuation of the first chart for the same table. ...
    (comp.databases.ms-access)
  • Re: Count and Sum Query
    ... > Hello need help with a query to get total count of all EFT and SRD ... Can you please provide a comma delimited sample data chart? ... If you know how to write DDL SQL, ... MyTableOneID AUTOINCREMENT PK ...
    (microsoft.public.access.queries)
  • Re: Pivot Chart; Missing Categories; Have you cracked this one?
    ... the Pivot Chart view of your query. ... query - the sort of thing that you would base a crosstab query on. ...
    (microsoft.public.access.forms)
  • Re: show Count of "empty" records
    ... Post your query SQL. ... MyTableOneID AUTOINCREMENT PK ... continuation of the first chart for the same table. ...
    (microsoft.public.access.queries)