Recent content by accessjunior

Hello, I'm still trying to figure out how to fix the issue of the data being multiplied rather than just summed when I use the Totals function. I've pasted the code below, and also have screen shots of the different tables and results. Basically, I'm trying to just create a query that...

Hi namliam, thanks for your response, and suggestions. I'm don't really understand what to do though. I didn't write any of the code, but just used the Totals option under the Design menu. Why would it triple amounts, and why would the problem be with dbo_BI_ARTICLE_DETAILS_SALES_DATA if this...

Hello everyone, I'm completely new to Access and know nothing about code. I have created a query and simply want to sum up the numbers 3 columns of "NET_QTY_FP", "STOCK_ON_HAND", and "NET_SALES_EXC_VAT_FP", but unfortunately it is tripling all of the amounts in each of the columns. Any idea...

OK, I will give that a try once back at work. I'm assuming the code applies even if it's for a query, not a table? Thanks Dave!!

Hi Dave, Yes, my intention is to total the last column! Can you explain how I do this, I'm not following from your post. Thanks! Massa

So, my question here is purely professional, despite Title of my post ;) I'm trying to figure out why my supposed "1:1" relationships are not functioning as such. Basically, I have 2 databases that are feeding from an external link, and another two that are static tables. I'm just trying to...