I have a developed a reporting system where various “Dealers” populate several entries of data via a report form each month. Each entry is a new data row. i.e Dealer 1 might submit 4 reports (data rows) in April, 1 in May, 2 in June et…
I have had a request for a quick view of which Dealers have submitted and those who have not, as long a I know about 1 submission that is fine, it makes no difference whether the Dealer has submitted 1 or 10 times, it is only a problem when they have 0 submissions.
See attachment for requested view and data table example. I am not sure how to approach this request? Grid, Form, ??? Any suggestions / inspiration please.