Report from Value list entries
Hi all. I have a database that records incidents where a rescue boat is used, the crew, incident. Incident type, fuel amount & value etc. I have been able to have the reports for what I designed the database for but as usual people want more. The crew positions in the database are [crew 1] [crew 2] etc and the entries are taken from a value list of 40 or so persons.
Now the requirement is that I want to get a report and have each of the crew grouped together that have been used, number of entries for each person and the time they were activated for. The start/end time and date of the incident is on the report.
Anyone care to tell me if It can be done or not and how to do it.