Don't know if I saw your original post but you have a big problem, namely
repeating columns (posted13, item13,etc.). We can't help until we know the
"facts" your database is attempting to store. What is your table about?

Evan

"Mykas_Robi" wrote in message
...
I have a table that consists of the following fields
name, number, effect date, term date, date posted1, item1, debit1,
credit1...date posted13, item13, debit13, credit13. I submitted a
question
on query design and was informed that my table is poorly designed.

I need to know what to break this table up that so that it is designed
properly. Please any assistance would be greatly appreciated.

Thanks and have a nice day.