Search results

Since this is coming from an Excel starting point, please point me elsewhere if needed, but was hoping a kind soul could assist as Google isn't helping me enough today... I have a 'dashboard' in Excel which calls through a number of queries from an Access DB which in turn pulls data from...

I have multiple queries brought together in a Union query (kudos to TexanInParis for assistance on that one) and instead of cutting through ways to import into Excel, created a simple query on the union and link to that from Excel instead. The issue is, when I query on the Union, I get the...

I'm trying to create an easy Excel sheet for a few departments at work showing production of certain items in the factory, split by product dept. I have the queries written in Access and am using MS Query to bring the (filtered) results through to Excel. How I have it currently is the...

I have a query producing a large number of records, calculating number manufactured and number sold of each product in inventory. This is based on number of boxes/products/sheets. Some items have not been moved in the month so have no record to pull through to this query so the result produces...