Timeline report update

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

Graham

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



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??
 
Take a look at Cross-Tab Queries. If there aren't so many months that they
will not fit on a page, that may allow you to create the report in the
manner you wish. Your Query can be the data source of the CrossTab Query.

Larry Linson
Microsoft Access MVP
 
Back
Top