Search results

I am trying to duplicate what we have in an excel file in a query in access. Our products are made of usually 2-3 components, essentially a kit. In Access, we already have the Inventory Qty for all components. In the excel file, we are computing the Product Qty using formulas within the cells...

So I have a fairly complex database that I've built myself for my business with the backend on sharepoint. It's been working very well but I've added a few things over the past few years, mostly on the frontend but I think I made some changes directly to the sharepoint lists also. Now I have...

I'm in need of tracking products sales. I have a a typical data base with an Orders Table (includes Order Date) and an Orders Detail Table which includes the Product Name, and Qty (sold per order). I'm trying to start with figuring out the best way to do this. Whether it's a form or report or...

I have a split database where I've been working on the front end mostly with some changes to the backend (some new tables, fields, relationships). I've been working with test data, though there are a few records in a few tables in the test BE that I'm going to want to retain, In the meantime...