got an idea from someone I was chatting to.

Basically pre-create a table that has every date over the years you're interested in. Then for each date create a column for each sorting arrangement you might want, e.g. day number, week number, month number etc. Then join the expenses table with this on date. Pretty cool...

Yes, that's what I recommend for building event calendars.

http://www.ClearviewDesign.com/Newbie

See the "calendar of events" demo.

But I wasn't sure it was worth the effort here. If you can use it for other purposes, though, it clearly simplifies lots of queries.

You remember who it was who suggested the trick? Curious if he and I have "tallked".

it's from Glenn, who has nothing to do with this forum, so I expect it would be extremely unlikely you know him...he does Crystal Reports