Query Repeats Data for Each Variable Creating Massive Query - How to Define Query

[AccessNoobie]

Hey,

I am new to Access and I have come across an issue where I am struggling prevent massive duplications of data. I am switching an unstable database from excel to Access and have pulled the data. However, I have found that my variables all repeat across from each other creating a huge query. Yet my data is specific to a Month & Year - for example in the original excel file I can filter for 01-Jun-22 and there a line of data with each variable and the specific forecast.

When I create the query linking in other variables it duplicates all variables creating a query of over 160,000 rows of data. Even after placing criteria constraints, I am still left with 1,000s of lines of data that are incorrect when I just need to duplicate the data from my original excel file.



Any advice or topic would be helpful, I just need a general direction to steer.

Thanks

[Welshgasman]

Without seeing the tables or query, we would just all be guessing.
I'll make mine. You have not normalized your db, just copied the excel layout. However as mentioned, just a guess.

[Micron]

Agree with that, although I suspect the main problem is a query with no joins. Then you have a Cartesian query and if there are 100 records in 4 tables, you'll likely get 100,000,000 records. The only way you could narrow that down with criteria is to use limited queries instead of tables, but the number of returned records will still be more than what you expect. In addition, if WGM is correct, it is likely that you cannot make joins even if you want to.