I have a table called "Maintenance Summary" that contains 1468 rows of data. I also have a table called "Months", which has no relationship to any other table or query, and contains 12 rows of data (numbers for corresponding months). I query various fields in the "Maintenance Summary" table, using no criteria, and 1468 records are returned (as it should be). However, when I insert the "Months" table in design view (without actually querying one of its fields), 17616 records are returned. I believe that "Maintenance Summary's" 1468 records are being multiplied by "Month's" 12 records. However, I have not set up any kind of formula or equation that I believe would perform this calculation. Does anyone have an idea as to what is happening? Any help would be appreciated.
Thanks,
Matt
Thanks,
Matt