B
Byrdd
I have been given the task of creating a monthly statement
that shows summarized Revenue and detailed expenses. I
created the main report using a SQL pass through query
totaling the revenue, but I am struggling with the Expense
sub-report. I built a table--because you cannot use a sub-
report with pass through quey--then created a query. My
sub-report will list all expenses for every month. I want
to limit the list to only current month expenses and give
me a year-to-date total.
I tried the dsum() but can't seem to get the criteria
correct:
DSum(" [tblOnrTrans]![otdebit] ","[tblOnrTrans]","
[tblOnrTrans]![otdate] between " & Forms![frmOnrStatMenu]!
[txtMthStart] & " and " & Forms![frmOnrStatMenu]![txtEnd])
Any suggestions?
that shows summarized Revenue and detailed expenses. I
created the main report using a SQL pass through query
totaling the revenue, but I am struggling with the Expense
sub-report. I built a table--because you cannot use a sub-
report with pass through quey--then created a query. My
sub-report will list all expenses for every month. I want
to limit the list to only current month expenses and give
me a year-to-date total.
I tried the dsum() but can't seem to get the criteria
correct:
DSum(" [tblOnrTrans]![otdebit] ","[tblOnrTrans]","
[tblOnrTrans]![otdate] between " & Forms![frmOnrStatMenu]!
[txtMthStart] & " and " & Forms![frmOnrStatMenu]![txtEnd])
Any suggestions?