I’m working on a baq right now where I have the part tran record summarized by transaction date for two different warehouses. Now I would like to get the data for merged together for one date and the quantity on that day. if the same date exist in both querys it brings that date in to one field. Let me know if you need more information.
Make your current query an Inner Sub Query. Then make e new query for the Top Level. in that new Query, add the inner sub query, then create a calc field to total the values, and group by date.