How can I provide a single field on a report that gets its value from another query which has no link to the report's main query/table? The standalone query simply provides a value I wish to display on the report, in addition to the report's own data. Because I can't "join" the two queries (no common key fields), I keep getting an outer join error message.
The report lists dated transactions grouped by client. That part works fine. But I also want to show the earliest (Minimum) date of ALL transactions (regardless of client). The main query provides the clients' data. The secondary query simply provides the single earliest transaction date (of ALL transactions) -- it has no "key" for joining to the clients' data. It's simply a single record/single field dataset. But I want this date to appear with every client's group. Its value would be identical for all clients. It's a variable, because it depends on the minimum date value for all transactions in a table of transactions, which could differ whenever the report is run.