>> I did notice that Excel apparently had no difficulty with the date 
>> column - or indeed any other column for that matter. So maybe that 
>> would work...
> 
> It would seem to me that the appropriate solution is to add up the 
> columns appropriately using excel.  Adding up columns is kind of what it 
> does best, after all.

Well, I'd like to be able to sort and filter the data and so forth - 
Access is specifically designed to be able to do that kind of thing, 
whereas Excel makes it a bit tedous.

By the way... I just realised. While you *can* move data between Excel 
and Access easily enough, there isn't actually a way to run a query in 
Access and get a chart as the result. I never thought about it before. 
But you'd have to run the query, copy the data, paste it into Excel and 
then fiddle about with chart options. There isn't a button in Access 
that says "please plot this as a pie chart" or something...

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message