Access queries

I am checking medical data for inconsistencies. So for example one report might check that a visit date is not before the patient's date of birth and another might check that the patient's height has not decreased over time.

In the olden days (!) I used to run SQL scripts on the command line, and would do a "spool" command at the begining of my work so that all the results went into a single output file which I could send to the client.

I do use a macro to kick off all the reports and run them in turn, rather than having to run them individually, but at the moment I then have to go through the output screens and copy and paste any output (ie data inconsistencies) into a Word doc.

I also think that you can run the results of ONE query into an output file.. but what I need is for all the results to go into just one output file.

I definitely still want an answer .. as no-one got back to me I worked round it again, but I redo this job every few months so please find me a solution if possible!