Search results

Hi I am trying to link to Access 2007 data in Excel 2007 using usual "Get External Data - From Access" route. Specifically I am wanting to link to certain Select queries. However, whilst Excel 2007 is apparently able to link to Queries and Tables, only certain queries are given as options...

Hi. I'm sure this is simple, but I'm just stuck. How do I get a query to output from a dataset just the records which have the latest date as per a Date field? I've tried using a max/first/last in the totals row, but this does not produce the desired result - for example, if a particular...