Select Customer, Order by Total - Graph Method?

[megamef]

Hi All,

I've created an access chart to show total sales ordered by customers.

I'm using a form with 5 comboboxes to select 5 particular customers from a customer table and pass this information into a query.

This query is then used on a report to create the graph.

Finally there is a button on my form that prints this report.


My problem is that the chart displays the customers in alphabetical order and I would like to order the customers numerically based on total sales value.

If I change my query so that the total sales order by is ascending then when I run the query from the report I am asked to enter a parameter value for the total sales field. Entering nothing and pressing ok simply returns the same graph I would have got had I not changed the order option at all.

*The customer filed in the report is set to group by and my totals field is set to sum - but I need both of these set to produce the graph.

Any Ideas?

 

[DavidAtWork]

Is this chart a simple 2 dimensional view of customers vs total sales value? Have you tried using the original query, make it a make table or append query that calculates the totals sales for each customer and puts the values into a temp table and then create another query based on the temp table where you order it by sales value

David

 

[megamef]

Yes it is a simple 2D view of customers vs total sales value. I should add that when i run the query itself and just type customer names into the pass through parameter boxes it worked fine, so I recreated the graph view again using the wizard and now I have ascending total sales by customers but I still get this pass through parameter for total sales field but the criteria for total sales is empty which is really confusing.

 

[megamef]

OK I've worked out what I was doing wrong, I was running a query to filter the report and the same query was being run when I was displaying the graph. Deleting the filter query line from the VBA code on my button removed the problem. Thanks.