Pivot Table?

  • Thread starter Thread starter Newbie
  • Start date Start date
N

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
 
Thanks - works a treat
Duane Hookom said:
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


Newbie said:
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
Click to expand...
Click to expand...
 
Back
Top