Recent content by treeman

Pat, Thanks for steering me in the right direction. Using your idea I actually was able to get exactly the result I wanted by just changing just a few things shown here. Thanks again!

Thanks, That sounds like a plan worth pursuing. I guess the only question is that there is no qty field in Products. That's what we're trying to establish from the available inventory of the components. Can I create a field with an expression or formula somehow. I do not need to (or probably...

Thanks but I already have that table. That's the ProdComponent Junction table you see in the query. It assigns components to each product even if the products share components. I'm not looking for what components we need to order. I just need to translate the already available component...

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...

sounds like a plan. Thanks. Hoping it gives me the option of copying with or without data

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 don't know what I'll eventually want or will need but to start, I do know that I want to view total product sales (units sold, i.e Qty), per product, per month for a particular year. I had tried a totals query but it returned too many results so know I'm thinking it might be a cross tab query...

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 may not have been clear. What I was getting at was not which BE data gets imported into which BE. The two options would be: 1) Moving his data from the old BE ,using an append query into, lets say, empty tables in the new BE. These new tables would be the same as the tables in the old BE...

Thanks Mark, My limited knowledge of coding leaves me to #1. Another thought crossed my mind based on some reading I've done: Does it make more sense for me to go the other way? Exporting my Test BE end (just structure (relationships, table definitions) not data, into the old BE with the...

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...