Originally Posted by
archie1_za
The recordset fot the database is not large, around 6000 records. However, the details per record is quite extensive. Probably around 100 different fields
I can't exclude the possibility not having a clue what those fields are and what kind of data they contain, that you really need so many fields, but somehow I have a feeling your data in not normalized. To put it simple way - when you can collect data from several fields to single field in separate table adding fields for linking and for entry classification, then do it!
Code:
What would be the best option to use? They would like to see a number of records at one time and not just one. Would the best option be a form with datasheet view?
I'd prefer form - subform structure with contionous subform.
Code:
Could I create a button that would export ONLY the filtered records to Excel where they can build their charts etc?
You can, and here are surely people who can advice, how to do that. I myself prefer Excel report file querying data from access database. Every user can have his/her own report file(s), and data will be refreshed when user needs them. Access database doesn't tend to wander around in different catalogues and computers like Excel files often do, so it will be much easier to query data from database having a fixed location, as keeping track of various Excel files over whole network. And there will be no problems with user having workbook open when Access wants to write some data into it!