Time sensitive reports

[kristin2]

I have created a financial database to contain all of our account information. I want to be able to create reports that give information by a date range. I also want to be able to create a report to print transactions for certain accounts.

 

[GingerR]

what have you attempted so far? do you have any queries written? are your reports designed?

my suggestion is to have a form, for example 1 with two text boxes. one name is txtDateFrom and the other is txtDateTo. user enters in the dates, pushes a button and the report is opened. in the sql recordsource for the report, the criteria for the date field is

between forms!FormName!txtDatefrom and forms!FormName!txtDateTo

for the second issue, the same thing. have a combo box on the form, with it's row source set to a table which has a unique record for each Account (i.e. tblAccounts). user chooses one from the combo box and hits a button. a report opens with the sql recordsource containing the criteria for Account Name

 forms!FormName!cboAccount

.

hope this is enuf to get you started.