Timeline Report

  • Thread starter Thread starter Graham
  • Start date Start date
G

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??
 
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
 
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??
Click to expand...


.
Click to expand...
 
Back
Top