Hello all ,
In the attached file, there is my sales table, and the form that I'd like to use as a report ..
I want to add a dsum in each control source .. that gets the sum of cash or quantities sold, based on the date range, and other criteria
I can't get the dsum to work with date range, it always returns #error
here is the syntax I'm using : =DSum("[total]","sales","[datein]=#"& forms![dailyreport]![startdate]&"#")
I am trying this after I tried the syntax for a range ..
any clue??
ps: I tried making both ends of the criteria a short-date, I tried making the row source of the start date field values from " select distinct ... " query
I still get #error