Numbers in columns

[Eddyoftheyear]

Hi Experts,

I have data result that looks like the below:

Date name Quantity Amount
03/2011 Smith 4 1000
03/2011 John 3 9000
03/2011 Bert 1 1500

I would like to be able to show the result,

if the quantity is more than one, then the quantity will be divided by the amount and spread in the next columns evenly

example,
march April May June
03/2011 Smith 4 1000 250 250 250 250
03/2011 John 3 9000 3000 3000 3000
03/2011 Bert 1 1500 1500

Any suggestions?

 

[Andrzejek]

I would like to be able to show the result,

Show the result in what? How?

And what about RED record:
[tt]
Date name Quantity Amount
03/2011 Smith 4 1000
03/2011 John 3 9000
03/2011 Bert 1 1500[red]
03/2011 Eddy 3 1000[/red][/tt]
How would you show it?

Have fun.

---- Andy

 

[Eddyoftheyear]

This will be query result that I will e-mail. I may tranfer to excel sheet.

 

[Eddyoftheyear]

For 1000/3, it could show as 333.33 333.33 333.34 or 333.00 333.00 334.00

 

[MichaelRed]

I would resist the urge. There is no DATA basis for the distributition!!!!

Some periods within the Distributition may even have negative values (in the "REAL" data!!!

It is a basic tenant of logic that you may not derive incividual elements of data from an aggregated source. To do so is to present ?dis-information?





MichaelRed