Recent content by gremo

After I posted the stupid question, I realized that..... sorry

Thanks for the info. I've already started redesigning this.... after it's done and set up correct is there a way to get the data that has been entered into the new database?

That's what I need to do. Pull data from several different tables into one part. Any quick suggestions on how to accomplish that?

I figured as much... Galaxiom I put the calculations in a query....can you explain how they are being performed in the form rather than the query?

See attached. One of the files is a linked file to our ERP but you should be able to see the queries and how they are built.

I tried 25 records earlier and can't get that to run either. Why would the form open (eventually) but the query will not. I've waited nearly an hour. If the form will open and show the calculations correctly, why won't the query itself :banghead:open?

QTy * cost does take 0 time. It's the grand total that I use the IIF. Part 1 qty * cost = Part 2 no cost part 3 qty * cost= grand total= tests for null values returns 0 if null then calculates the total

My database setup is this. It pulls the part number, costs, price etc from our ERP and allow (via a form) to fill in the Bill of Materials for the particular part. All of the components are based off of combo boxes which are based on queries from the inventory master table. The form I designed...