>I tried to add all the table name to each field that did not help. Thanks Todd.
>sherry
I meant more, if you added them we could understand the question better, not that it might help the sql to run correctly. Looking at your code, its not clear if the fields are coming from the parent table or the child table.
Also, you might give a quick description of the relationship between the tables as in: Master has one record for each month, child has many records for each month and they are linked by the id number.
We might be able to help better if we have a little more info on this one. :-)
--Todd Sherman
-Wake Up! Smell the Coffee!