So I've been attempting to do something with FMPro for a while now and I keep coming back to it so my mind is fresh. But I'm all out of ideas. I have a feeling it might be easier than I think. Here is what I need:
Basically I have a set of about 30 or 40 queries. I use these queries to get a total number of records. So, for example, I have a query that shows me how many pieces of widget x I have in stock, or another is how many pieces of widget x had a manufacture date between two dates. So I run these queries and then of course I see the number of records on top. But what I'd like to do is consolidate all these queries into a report or a layout that I can click on and see the totals of the queries in one sheet. I've tried everything I can think of. This has been going on and off for about 6 months so I decided to get some help. Does anyone know how I can do this? Thanks!!