Control source - problem

[polgara]

Hi

I have got a query
Organisation, Team,Quarter, Sales

I'm trying to set up a form for our users to view this data for each team and need to be able to view it as follows:

Org Qtr 1 Qtr 2
Sales

On the form I've got text boxes with control set to 'Sum of Sales' but I need to only show the ones relating to the appropriate qtr - how do I go about this?

*** going on a training course soon so hopefully won't be asking such silly questions

 

[Robert Dunstan]

You might want to change your query to a cross tab query in order to get the desired grouping and results. In the design of your query go to the 'Query' menu and select Crosstab Query. In the grid this will add a couple more lines..Total and Crosstab

The cross tab allows you specify how you want show the field i.e. column heading, row heading or value. In the totals field you can perform your calculations.

HTH
Rob

 

[Robert Dunstan]

You might want to change your query to a cross tab query in order to get the desired grouping and results. In the design of your query go to the 'Query' menu and select Crosstab Query. In the grid this will add a couple more lines..Total and Crosstab

The cross tab allows you specify how you want show the field i.e. column heading, row heading or value. In the totals field you can perform your calculations.

HTH
Rob