Adding togther the results of a calculated field from 2 different queries

[Debron101]

This seems that it should be such an easy thing to do...
In Query 1, I am multipling an order quantity from 1 table and Sales Price of another table to give a total order cost
In Query 2, I am doing the same but with a different table for the order quantity
I now want to add the total order cost together.


The result it always blank.
What I am missing?

[orange]

Post the SQL of your query(s).
Perhaps you could describe the purpose of your database and tell us about the tables behind the query(s).

[Debron101]

SELECT Order_With_Values_050421.[Item Code], Order_With_Values_050421.[Item Name], Order_With_Values_050421.Total, Order_with_Values_190321.Total
FROM Order_With_Values_050421 INNER JOIN Order_with_Values_190321 ON Order_With_Values_050421.[Item Code] = Order_with_Values_190321.[Item Code];
I want to add the 2 order_with_values colums together.
It just seems like a simple thing but I must be missing out a stage,
Thanks in advance for any help

[mike60smart]

Hi
Can you upload a zipped copy of the database?

[CarlettoFed]

A solution could be the following:

SELECT Order_With_Values_050421.[Item Code],  Order_With_Values_050421.[Item Name], (Order_With_Values_050421.Total +  Order_with_Values_190321.Total) AS Totals
FROM Order_With_Values_050421 INNER JOIN Order_with_Values_190321 ON  Order_With_Values_050421.[Item Code] = Order_with_Values_190321.[Item  Code];

[Debron101]

Hi
Can you upload a zipped copy of the database?

I have uploaded the zipped file

[Micron]

Look at your data in the query. There is no record with a value in both fields (i.e. no item code exists in both tables based on that query) so there is nothing to add.
You would be doing yourself a favour if you didn't use special characters and spaces in your object names. You should not be creating multiple tables that look the same either. Access is not Excel, like where you might create multiple sheets that look the same. I think you need a primer in db normalization and design.

[ssanfu]

In addition to Micron's comments about not using spaces/punctuation/special characters. you should never begin object names with a number. The Access gnomes can get obstinate and cause problems.

You need to be able to determine what are the attributes you want to record (a sales date) and what is data. Naming the tables with the "UK Del Date" (sales date?) means you could potentially have at least 356 tables.

It would help if you would answer orange's question: "Perhaps you could describe the purpose of your database and tell us about the tables behind the query(s).".