I have, what I think will be, a very difficult question. I do not even know if this is possible.
I have an excel workbook that just dumps information into an access table. I created a query in access that sums totals based on the coresponding "service" with Group By. I have created aform in access that a person can view this information.
What I need to do is be able to show that information back in excel. I dont want it to show in a table format. I would like for it to populate a specific cell with one of the "sumOf totals" from the access query. The filter qould based on the the "service" name that is showing in another cell.
I hope this provides enough insight for what I am trying to accomplsh. Please let me know if I need to exaplin further. Thank you so much for your help on this!