FreezieAddict
Technical User
Hello,
I used the Ledger database that Access creates automatically for you and added & modified some bits to what we need. There is a Report where you are prompted to enter 2 dates and it prints out all records that fall in between them. Basically a "transaction" contains the following:
Transaction Number (the cheque number)
Date (date)
Description (the payee or recipient)
Withdrawal amount
Deposit Amount
Account (property payment/receipt is for)
The problem is this:
1) i have tried to modify the "Account Summary" report by adding a "Description" column to the end of it, but this column remains blank. When i run the report after the prompt for dates it also prompts you to enter a "Description" and if you DO enter one, it prints it all the way down the column for every transaction regardless.
2) to get around this, i tried to make a new report displaying what i wanted (i.e. everything), now it shows up the way i like it to but it doesnt prompt for dates.
I saw the other posting about date specific reports, but i wanted to ask if it was possible to link a new report to a query thats already being used? All i want to do is have a report that prompts for date entries and shows all details of what i want, is that so hard?!
would any answers please be clear & simple (emphasis on the SIMPLE!), i'm not very advanced at any of this (was it that obvious?).
thanks,
FreezieAddict =^_^=
I used the Ledger database that Access creates automatically for you and added & modified some bits to what we need. There is a Report where you are prompted to enter 2 dates and it prints out all records that fall in between them. Basically a "transaction" contains the following:
Transaction Number (the cheque number)
Date (date)
Description (the payee or recipient)
Withdrawal amount
Deposit Amount
Account (property payment/receipt is for)
The problem is this:
1) i have tried to modify the "Account Summary" report by adding a "Description" column to the end of it, but this column remains blank. When i run the report after the prompt for dates it also prompts you to enter a "Description" and if you DO enter one, it prints it all the way down the column for every transaction regardless.
2) to get around this, i tried to make a new report displaying what i wanted (i.e. everything), now it shows up the way i like it to but it doesnt prompt for dates.
I saw the other posting about date specific reports, but i wanted to ask if it was possible to link a new report to a query thats already being used? All i want to do is have a report that prompts for date entries and shows all details of what i want, is that so hard?!
would any answers please be clear & simple (emphasis on the SIMPLE!), i'm not very advanced at any of this (was it that obvious?).
thanks,
FreezieAddict =^_^=
