Have a question and do not how to do this. What I am trying to do is pretty
hard to explain but here I go. I have a table that has a units mtoe in it
with fields like duty title/description/req personnel for that postion and
required personnel for that postion. What I did was take that and broke it
down to where each postion is only req one person. Know here comes the tricky
part. is there a way to go on the form and combined the postion back together
again so it looks just like the mtoe.
If you need more info please let me know.
>Have a question and do not how to do this. What I am trying to do is pretty
>hard to explain but here I go. I have a table that has a units mtoe in it
[quoted text clipped - 5 lines]
>
>If you need more info please let me know.
It might help if we knew what a "mtoe" is. It would also help to know the
structure of your tables, how they are related, and the desired output - you
know all of this but we don't!
All I can say based on the information you have posted is "create an
appropriate query joining the tables you have created".
John W. Vinson [MVP]