I’ve looked into this issue and have not found a solution for my issue. I’ve analyzied the SQL code and cannot find any issues (I’m not good at SQL) and have spent about 2 hours trying to solve the issue but I cannot figure it out.
The table is used for a video game, it is a database for keeping track of shooting range scores in Ravenfield. I’ll go ahead and post the SQL for someone to anaylize.
The table is set up by joining multiple queries together, however, they’re not complex queries, and the data is fairly simple. The main table is the weapon information table, and the rest are the range tables.
Here is the sql for those who want to look at it to tell me if something is wrong with my SQL:
SELECT [Weapon Information].[Weapon Name], [Weapon Information].[Weapon ID], [Weapon Information].[Sub ID], [Weapon Information].[Based On], [Weapon Information].[Country of Origin], [Weapon Information].Type, [Weapon Information].Caliber, [Weapon Information].Capacity, [Weapon Information].Manufacture, [Pistol-1 Final]![Final Score]+[Rifle-1 Final]![Final Score]+[Indoor Range Final]![Final Score]+[Testing Field Final]![Final Score]+[CQB-2 Final]![Final Score] AS [Final Score], [Pistol-1 Final]![Final hits]+[Rifle-1 Final]![Final hits]+[Indoor Range Final]![Final hits]+[Testing Field Final]![Final hits]+[CQB-2 Final]![Final hits] AS [Final Hits], [Pistol-1 Final]![Final Misses]+[Rifle-1 Final]![Final Misses]+[Indoor Range Final]![Final Misses]+[Testing Field Final]![Final Misses]+[CQB-2 Final]![Final Misses] AS [Final Misses], [Final Hits]/[Final Misses] AS [Final Accuracy]
FROM (((([Weapon Information] INNER JOIN [Pistol-1 Final] ON ([Weapon Information].[Sub ID] =