Thank you. Worked like a charm.
but now I want to add in a "Notes/Explanation" Column which I'm finding
hard becuase I know that this report is made up from about 20+ queries,
but I dont want to have to put in 20+ labels when the report is
created.
Right now I have my reporting looking like:
Query1 Result1
Query2 Result2
Query3 Result3
but I need soemthing like:
Query1 Result1 Notes1
Query2 Result2 Notes2
Query3 Result3 Notes3
1) Is it possible to create perhaps a TABLE of my results now rather
than a REPORT of course in an automated process? Either throught VBA or
throught MS Access interfaces
like so:
QueryName | Result | Notes
------------------------------------------------------
so that I can just type it in to the table and then print out the full
results in the end to a report?
Keith Wilby wrote:
<ja********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com... Can you please elaborate?
I'm not sure what you mean by including them in a separate query?
perhaps an example. is the SQL then just appended all together?
Save your three queries. Open a new query and click the add table button.
Click the queries tab and select your three saved queries. Drag the fields
from your queries onto the grid. I tried it on a simple example and it
seemed to work OK. No need for any joins.
Regards,
Keith.
www.keithwilby.com