If you're trying to put this into a single table then that behaviour wouldn't surprise me (In fact, if anyone were surprised then they are missing a great deal).
You don't include any real detail in your question (which is a shame as it wastes your time as well as everyone else's.), so it's hard to give definite instructions, but what I can say is that you need to consider your data layout (where, and particularly in which tables, you store each piece of data) very carefully before ever looking at building anything from that data.
It seems clear that you have tried to do this the wrong way around (which, to be fair, seems to be the most common approach, even though it makes no sense given a modicum of thought). The data layout (or schema) is the bed-rock that everything-else is built upon. If it's not right for your requirements then making your project work will always be a struggle. This article (
Database Normalisation and Table Structures) is probably a very good place to start from.
If that's a step too far, then consider some of those found in :
- Microsoft Access Tutorials (Strive4Peace).
- Microsoft Access Tutorials
- Microsoft Office Tutorials.
- VBA Tutorial (Excel).
They may not all suit you but I expect you'll find some of them very helpful.