Query of a table with one record results in all records in database to be displayed

[ZodiacPilot]

I have a table with one record in it. I created a query with all fields defined and when run it shows the same field for every record in my database.

Table = date
ID
Name
Darted Yes/No
Refrigerated Yes/no
Notes


Treatment Results
__________________________________________________ ________________________________
Date ID Name Darted Refrigerated Notes
__________________________________________________ ________________________________


8/15/15 00:00 3MHM1 Mama Freckles Yes Yes









qryDartingInfo
__________________________________________________ ________________________________
Date ID Name Darted Refrigerated Notes
__________________________________________________ ________________________________
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes
8/15/15 00:00 3MHM1 Mama Freckles Yes Yes


I have a total of 102 records with horses that have not been darted and it looks like my query is appending the results of the one record in the table to every horse.

Any and all help is greatly appreciated.

[June7]

That is normal if the query does not have a JOIN clause. How are these tables related? Post the SQL statement of the query.

[ZodiacPilot]

Here is the sql statement. I added another record to the table and now there are two records listed for each horse in the database but only the records that are in the table are repeated over and over again.

SELECT ContraceptiveTreatment.DateTime, ContraceptiveTreatment.ID, Alias.Alias, ContraceptiveTreatment.Delivery, ContraceptiveTreatment.Refrigerated, ContraceptiveTreatment.DartNotes
FROM Alias, ContraceptiveTreatment;

[June7]

As I said, there is no JOIN clause. This is basic Access query functionality. Review http://www.opengatesw.net/ms-access-...cess-Query.htm

Did not answer the question. If you want to provide db for analysis, follow instructions at bottom of my post.

[ZodiacPilot]

You are the master of shredding the Black Diamonds! I was not joining the tables correctly. Thank you very much.