Hi there how do I put data from Access into Excel and then make a graph out of it? Also how do I put all the info from both Access and Excel into a Word document and have it automatically update whenever the data in the other applications is updated? I hope that's not too much to ask in one question. Thanks for any help.

You use linking for the Word piece (look it up in the help files, theres oodles of useful stuff there. Essentially, the easiest way is to copy your source (so, say a range in Excel), then go into your Word document, choose Edit...Paste Special..., then select the 'Paste As Link' option over on the left - Hey Presto! You can change the Excel sheet, and the Word Doc updates!) Getting data from Access to Excel is easy, if you have a clear idea of how you want the relationship to work. If you just want to take data over once from a table, then just copy and paste and you're done. If you want to do this 20 times an hour, then you can set up a macro which exports a table as an Excel file. Or you can use a query from Excel to retrieve the data from your Access database. I always go for this last option, because I prefer Excel to be in charge (Access is too 'Open-House') and its simpler in the long run. Try using "Data... Get External Data" from Excel, and choose the most appropriate options. Its very straightforward and very robust too. For a more complicated relationship, you can return SQL query results against your Access DB from Excel, but that may be going too far depending on what you actually want. Hope thats not too rambling for you! Cheers Tom

Hey Tom sorry I've been away for a while. I guess you won't see this but just incase thanks a lot for the very useful information.