B
Brian
I am in need of some help formatting a report. My table looks like this:
Item Description as a text value
Month (yyyy-mm) as a text value, not date
Dollar Amount
I didn't use a date field type because I noticed that despite what it shows
on the screen, it actually stored a specific date in the table, which I
didn't want. (I am using SQL Server 2005 database linked into an Access 2007
front end.)
So, for example, I might enter "Rent", "2009-11", and "$2000". That entry
will exist for every month. I might enter "Insurance", "2009-12", "$150" and
pay it every 3 months. And so on.
What I need is a report that looks like this:
Item 2009-11 2009-12 2010-01
2010-02
------------------------------------------------------------------------------
Rent $2000 $2000 $2000
$2000
Insurance $150
Food $365 $412 $282
$325
And so on, printing out 12 months.
Does anyone know how I can create that kind of report? And are the fields
in my table OK for creating that kind of report?
Thanks!
Item Description as a text value
Month (yyyy-mm) as a text value, not date
Dollar Amount
I didn't use a date field type because I noticed that despite what it shows
on the screen, it actually stored a specific date in the table, which I
didn't want. (I am using SQL Server 2005 database linked into an Access 2007
front end.)
So, for example, I might enter "Rent", "2009-11", and "$2000". That entry
will exist for every month. I might enter "Insurance", "2009-12", "$150" and
pay it every 3 months. And so on.
What I need is a report that looks like this:
Item 2009-11 2009-12 2010-01
2010-02
------------------------------------------------------------------------------
Rent $2000 $2000 $2000
$2000
Insurance $150
Food $365 $412 $282
$325
And so on, printing out 12 months.
Does anyone know how I can create that kind of report? And are the fields
in my table OK for creating that kind of report?
Thanks!