Timeline Report

[Graham]

I have the data in a report

Project: [Project1]
Starting Month: [Starting Month]
# of Months: [# of Months]

Product Quantity
[Product1] [Quantity1]
[Product2] [Quantity2]
[Product3] [Quantity3]
[Product4] [Quantity4]


Calculated Field [QM] = [Quantity]/[# of Months]

Im wanting a report that looks like:

Project: [Project1]
Product Month1 Month2 Month3

[Product1] [QM] [QM] [QM]
[Product2] [QM] [QM] [QM]
[Product3] [QM] [QM] [QM]
[Product4] [QM] [QM] [QM]

As many colums of months as the number specefied in [# of
Months]

How can i create this??

 

[Larry Linson]

Because we don't know how your tables are laid out and how your data is
stored, we can't give you an answer. You've described very nicely the output
you want, but now you need to describe what data you have.

Larry Linson
Microsoft Access MVP

 

[Guest]

In a query I have
[Project] [Starting Month] [# of Months] [Product]
[Quantity] and the calculated [QM]

-----Original Message-----
Because we don't know how your tables are laid out and how your data is
stored, we can't give you an answer. You've described very nicely the output
you want, but now you need to describe what data you have.

Larry Linson
Microsoft Access MVP

I have the data in a report

Project: [Project1]
Starting Month: [Starting Month]
# of Months: [# of Months]

Product Quantity
[Product1] [Quantity1]
[Product2] [Quantity2]
[Product3] [Quantity3]
[Product4] [Quantity4]


Calculated Field [QM] = [Quantity]/[# of Months]

Im wanting a report that looks like:

Project: [Project1]
Product Month1 Month2 Month3

[Product1] [QM] [QM] [QM]
[Product2] [QM] [QM] [QM]
[Product3] [QM] [QM] [QM]
[Product4] [QM] [QM] [QM]

As many colums of months as the number specefied in [# of
Months]

How can i create this??

.

 

[Larry Linson]

In a query I have
[Project] [Starting Month] [# of Months] [Product]
[Quantity] and the calculated [QM]

Thank you. I guess I overlooked that.