C
ComputerStudent
I'm using Access to build a database at work. I am entering data on a daily
basis from invoices that I wish to sumarize by various periods of time
(daily, weekly, monthly, etc....) so have built From and To parameters into
my query. When running reports, I get #Error for the report totals. If I
build my dates into the query as >=09/01/2007 And <= 09/30/2007 I can get a
total on the report. The query works with the parameters, but not the
report. I am using the =DSum function in the report footer to obtain my
totals. Any ideas what I am doing wrong?
basis from invoices that I wish to sumarize by various periods of time
(daily, weekly, monthly, etc....) so have built From and To parameters into
my query. When running reports, I get #Error for the report totals. If I
build my dates into the query as >=09/01/2007 And <= 09/30/2007 I can get a
total on the report. The query works with the parameters, but not the
report. I am using the =DSum function in the report footer to obtain my
totals. Any ideas what I am doing wrong?