I'm pretty new to access, but my boss wants me to try and consolidate our massive folder of monthly excell data into a database. So far, I have a few different tables with production data in them. I'm trying to get a daily total (I don't even know if this is the best way to do it) using a sum query. I started by writing a separate query for each table, and it worked fine. When I combine them, the numbers are totally wrong. 10 to 50 x larger than they should be.
Here is the original query, which works fine:
SELECT Bench.Date, Sum(Bench.Total_ft) AS Bench_Feet
FROM Bench
GROUP BY Bench.Date
There are three of these, which all work. This is the combined query:
SELECT Daily_TG.Date, NZ(Sum(Bench.Total_ft),0) AS Bench_Feet, NZ(Sum([Holes_L]+[Holes_R]),0) AS Jumbo_Holes, NZ(Sum(Bolters.Bolts_8),0) AS 8_ft_bolts
FROM Bench, Jumbos, Bolters, Daily_TG
GROUP BY Daily_TG.Date;
Note: Daily_TG.Date is tied in a one to many relationship with the date field in the other 3 tables.
Any thoughts? I've been fumbling through this for 3 days now.