Reports

[Kim M]

Good afternoon

I want to create in Access 2003 a report that will have MTD data on the left
and YTD data on the right side.

Example:


Cust ID Customer Name March 2008 January-March 2008

1234 Kim $125.00 $250.00
3456 Bill $50.00 $130.00


I would like to create a lot of reports with the following problems.

??

Do I create two queries, one for MTD, one for YTD
Do I create a report with sub report?

Any help would be greatly appreciated

Kim Movesian

 

[Klatuu]

Can you show us your table layout, please?
It would help decide where and how to do this.

 

[Kim M]

Thanks Dave for your quick respond

All data is coming from two tables.
The main data is queried for both the monthly and yearly data.
The other table is used for the print format. All tables are linked by
Customer ID

I can print a monthly report and then a yearly report but would like to
combine them on one report. I would also let to compares this year with last
year figures.


Monthly Data Yearly Data

Cust ID Cust ID

The print table help print the data by Company, Region, distributors….
The Cust ID is also linked to both tables above…


I hope this will help with my problem.

Thanks again

Kim

Dave, could you recommend any books for advance reports in Microsoft Access
2003.

 

[Klatuu]

Sorry, Kim, but that is not enough Info. I really need to see the table
layout including field names.

I don't know of any specific books on reports, but my favorite Access Books
are "Access 2002 Developer's Hand Book" There is a Desktop volume and an
Enterprise volume. They are by Litwin, Getz, and Gunderloy and published by
Sybex. They did not produce a 2003 version, but there is not enough
difference between 2002 and 2003 to make a difference.

One thing you might try is to create a Group By (totals) query to sum the
YTD data by CustomerID and create another query that uses the table with your
monthly data and join the YTD query to it by CustomerID.

 

[Kim M]

How could i forward you the data?
I enjoy access both I was a dBase programmer.
I just wrote code.
I never used the report generator in dBase.
Thanks

Kim

 

[Evi]

The only way I can think of you doing this is to have a 2 column main
report. The JantoMarch data will be in a subreport linked by CustID and
placed in the CustId footer. You will need to set up the footer using
Properties so that you have a column break Before the footer and a Page
Break after the footer.
Evi

 

[Klatuu]

There is really no way to send it to me.
Sorry, but for security reasons I don't post email or ftp info.

I started on Dbase also, then to FoxPro, then to Acces
Well, actually I started with COBOL, then BASIC bfore DBase.