Originally Posted by
MrXYZ
Yes, sorry, this is exactly my structure. Each field is labelled by week number.
Then you don't have a Relational Database, you have a Spreadsheet, which is what June7 was getting at!
Check out CyberCow’s list of links (in Post #5) on the subject of Normalization:
http://www.utteraccess.com/forum/Use...-t1986675.html
Once your Database is properly Normalized, this and most other tasks will be much easier to do!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007