I've stumbled on this challenge for quite some time and thought I could get some great piece of advice within the community. I need to add a Grand Total row to a select query !!!
I have designed a query that filters through my records to indicate equipment needs for a specific location.( See 1_Query_Select_Design). The query prompts for the region, Type of facility (airport/ seaport) and finally the name of the facility and upon values entered by the user returns a set of rows for the specific location ( See 2_Query_Select_Result). So far so good.
Now I need to summarize the total number of equipment on Record and Needed on that returned selection by possibly inserting a row at the end of the selection that will compute the items (3_Adding_TotalRow_To_Sele
I've read that I should use a temporary_table on my query design window that sort of store some data temp. Anyways, I have no idea how to implement screencast 3.
Hope you can lend some dearly needed help.
Many thanks in advance,