My user wants a report with (unrelated ish) data on it. The unrelated bit comes mainly because of the old design of the database and the fact it's not quite a relational model.
I can run several queries to get the data he wants. But how can I then get it onto the report.
So I want field 1 from query 1, field 2 from query 2 and field 3 and 4 from query 3.
I know how to run a query from VBA but how do I then get field 1 through 4 onto the report.
I'm sure I've done this but lost too many brain cells since
I can run several queries to get the data he wants. But how can I then get it onto the report.
So I want field 1 from query 1, field 2 from query 2 and field 3 and 4 from query 3.
I know how to run a query from VBA but how do I then get field 1 through 4 onto the report.
I'm sure I've done this but lost too many brain cells since