Recent content by BigAL

Hello all, I was wondering if someone could help me out. I'm hoping this is relatively straightforward but I'm not very experienced with SQL and have tried numerous variations on the query syntax but with no success. I have a load of data in an excel spread sheet that I'm trying to put into...

Hi Alan/jdraw, This is really great stuff so thanks for your contributions. I've split up the tables as per Alan's suggestion and can already see that, come year end, I can loop through tblYearlyData and update records with: INSERT INTO tblYearlyData [Column1], [Column2], [Column3] VALUES...

Hi Alan, Thank you for your response. It will take me some time to go through all this, but the table structure you suggested looks very promising. Alex

Hi all, I'm sure this is really simple but I've just picked up a copy of Access 2010, am completely out of my depth and I really don't know where to start. Background: I have managed to move a table I was maintaining in Excel to Access, but would still like to use Excel as the front end...