Hi all, I'm new to access and it's been working fine till now, and seems like my mind has stuck on a simple problem.
I have table listing dates and number_of_items_sold, I've built a query and a table, and using Sum([number_of_item_sold]) in the report repeats the value for each date (I.E. if i choose a range of 3 days, it is repeated 3 times). Putting the sum in the footer or header gives me error.
All I want is the sum of product for range of dates "that I entered as criteria" to use as subreport in another report.
Thanks.