My data table looks like this:
Day|employee number|bins finished
I want a single line on my report to show a week's worth of product (finished bins). An employee normally will have several entries per day.
The first bin field on the first line of my report was simple:
=sum ([bins finished])
For the next day, same line, I tried this for that fields data:
=Dsum("[bins finished]","bin table","[day]=#" &[pay period start date]&"#+1" and "[employee number] = 1")
Should just get bins for employee one but getting all employees.
Bear with me, I am not good at this at all. I program with access one every several years.