Hi All,
I am setting up an incident database, i have created a qry for the fields I want, the only condition is the incidents that are closed don't show on the report, this function is working.
I have created a report from that query but it is not showing all the data, i have set some fields to be collapsible but I think that is only when the fields are blank.
I have attached screenshots of the query and report showing the difference.
Any suggestions would be greatly appreciated.
Kat