Timeline report update

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??
 
L

Larry Linson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timeline Report 3
not repeating text boxes in reports with columns 19
transpose table in MS Access 0
Updating field shown on report automatically with update on table 1
Crosstab Query results/ Sum 7
Need Help Using Calculated Field or Item in Pivot Table 1
can't get sum in reports 4
2003 Access Reports Question 1

Top