I'm still doing some Access development.... I spent ages trying to do a query in a way that conformed to ANSI SQL and not using Access SQL functions. Which took about 2 hours longer than it should have. Plus I had to make a view because I couldn't get it to do subselects. Which sucked.
Anyway, I got it working. Now all I have to do is work out how to do interval reporting and then I'm done. It's too long since I've done any software stuff.