I have 2 lists.
List one (1) captures a set of data from users (weekly reports). The other list (2) will only query the data to consolodate all submissions from list One (1). The query is based on the week ending field (Date Picker).
Process:
1.) Users submit weekly reports to list one.
2.) The Admin opens a custom form in list (2) and ...