2 Problems my 2003 file. and a query that won't group the records by month

[kizmissy]

my database was working fine until a new month was added in the attendance now each staff member has about 20 records when they should only have two. if i remove the second month it corrects its self but i can't do that permanently

also i have office 2010 but the office has 2003 so i saved it to 2002-2003 file format and it was working fine up until today when it has started to give and error message
Which Reads:

Your Microsoft Office Access database or project contains a missing or broken reference to the file 'ACEDAO.DLL' version 12.0

[orange]

What exactly in plain English are you trying to do?
It appears that your tables are not Normalized. You have similar fields in each Table???

[kizmissy]

Sorry I am new to access so I don't actually know what you mean by 'normalised' but basically this is a record of attendance for a small group of staff basically my problem lies within the all about hours query there should be two records per staff member as it should show all the details month (Oct and Nov) it worked fine when there was only one month or hours but now there are two instead of bringing up two records it brings up several. I realise my database is unconventional but I really have no idea how to do it any other way, I don't have any real understanding of SQL so its all pretty much been done through wizards.
Hope this makes my enquiry more clear as i really do need some help.

[orange]

Normalization is critical to database design.
Here are some links to help:
Database principles http://forums.aspfree.com/attachment...2&d=1201055452
Normalization http://www.rogersaccesslibrary.com/T...malization.zip
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

12 steps to better databases http://www.rogersaccesslibrary.com/f..._Databases.zip

[kizmissy]

If i read these links will it help me fix my actual problem or are you suggesting i start again

[orange]

Yes. I'm suggesting that, if you do not know what Normalization is, then research Normalization, follow some samples, become familiar with Normalization, and your database life will get a lot easier.

Good luck.

The best analogy I can think of quickly is:
you are wanting to be an airline pilot, but you first need a flying lesson.

[kizmissy]

well thank you for trying to help but i asked for help with a specific problem not for help to start from the very beginning. I volunteer for a charity (the workplace for this database) I do not get paid to do this, the database works fine for its purposes aside from that one query which just needs a little tweaking to function for more that one months worth of data.