Pivot Table?

[Newbie]

Hi,

I would like to be able to query a table that will give me no. of records
per customer by month in the following format
Jan Feb Mar Apr May June July etc
Cust1 2 5 10
cust2 0 1 5 0
Sum(Records)
cust3 15 6

I want to be able to display this on a form and on a report and also click
on a button that will give me a graph of the same information

how can I achieve this?

Thanks

 

[Newbie]

Thanks - works a treat

This is a crosstab query. Set the
-Column Heading to Format([YourDateField],"mmm")
-Rowing Heading to [CustomerField]
-Value Count([CustomerField])
Then set the Column Headings property to:
"Jan","Feb","Mar",..."Dec"

Use the graph wizard for forms to create a graph. If you get lost, it
probably weren't hurt to start a new thread since you asked two separate
questions.

--
Duane Hookom
MS Access MVP

Hi,

I would like to be able to query a table that will give me no. of records
per customer by month in the following format
Jan Feb Mar Apr May June July etc
Cust1 2 5 10
cust2 0 1 5 0
Sum(Records)
cust3 15 6

I want to be able to display this on a form and on a report and also click
on a button that will give me a graph of the same information

how can I achieve this?

Thanks