Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
toniolo
Starting Member
14 Posts |
 Posted - 2008-05-20 : 06:46:18
|
| I have a large database, with around 600,000 records of information about customers transactions.There are 2 tables:Table 1 - Contains the columns : Name, account, address, phones, etc..Table 2 - Contains information about their transactions with the columns: Name, accounts, transaction date, Transactions by Cash (C), Electronic Transactions (E).This database covers transactions from 2005 until 2008.What I need is to make access display the following information per account: Jan05 Feb05 Mar05 C E C E C EName Account xx xx xx xx xx xxThe report above should count the number of transactions paid in Cash (C) and Electronic (E) per account and display it per month.I managed to prepare a report that shows the COUNT of all transactions from 2005 to 2008. No problems there.I also managed to prepare a report that shows the same information per a single month (not that difficult as I made a query filtering the main database per range of dates).Does anybody have any idea how I can make this report that shows a list of account and their names, and show the COUNT of transactions per month (both C and E) ?Thanks a lot. |
|
|
|
|
|
Working with Reports - Large database