How to do this - Newbie ?? [message #88945] |
Mon, 30 June 2003 08:53 |
michelle
Messages: 19 Registered: August 1999
|
Junior Member |
|
|
I have a table that has one record for each month.
My report will show this month's data, this month a year ago and YTD data. In a table type format.
What is the best way to do this? I've managed to get myself quite confused.
Thanks
|
|
|
Re: How to do this - Newbie ?? [message #88953 is a reply to message #88945] |
Mon, 07 July 2003 01:48 |
sujit
Messages: 94 Registered: April 2002
|
Member |
|
|
hi,
you can do it by using self-join query. alternative way is to use formula columns(easier way), but i do believe that the use of formula columns will slow up data. Try it your own.
Sujit
|
|
|