Unammed view
Hi,
I would like to report on sales from different tables using an unamed view
query, which is like a subquery that has 3 UNION selects.
What would be best way to go about that from Crystal?
.
Relevant Pages
- Re: Return Query Result when no data
... Union doesn't seem to like it. ... which are not appearing in your current query, ... don't match Debtmain as they don't have a debt for the date. ... Sales table has 3 fields: AccNo, Week and Turnover, Debts table also ...
(microsoft.public.access.queries) - Re: Multiple subqueries in a union query
... Create a query that uses TableA, TableC, and QueryD. ... If that's the right records, switch to SQL View, and UNION the similar ... Access 2003 that works as long as a second subquery is not added to the ...
(microsoft.public.access.queries) - Re: Return Query Result when no data
... The SQL I posted works fine - I built two test tables and checked. ... Do the two separate Select parts of your union query each work, and return the correct data? ... But since your wanting records from the other table, which are not appearing in your current query, you need a separate query to retrieve them, and then a Union query to combine both recordsets. ... I want a query to show all accounts in the Debts table for a given week where there is an outstanding balance and where there's a Turnover from the Sales table, ...
(microsoft.public.access.queries) - Re: Calculations on Null Values
... I have a list of clients and sales amounts ... A Totals query will average data from this table correctly - group by ... You can create such a table and use a Normalizing Union query to ...
(microsoft.public.access.queries) - Re: Multi-Level GROUP By Clause is not allowed in subquery
... Do you mean that I change select query to union query and at the end to ... MS Access lets me create the report using the query. ... Does MS Access report support subquery? ...
(microsoft.public.access.reports) |
|
