Recent content by Noelie2000

Sorting Problem I have used the following, as discussed in this thread: Birthday: DateSerial(Year(Date()),Month([DOB]),Day([DOB])) Unfortunately when I try to sort it returns a too complex expression. Any ideas?

Thanks. I'll try that and point taken about saving, effectively it would change every year so I will try it as a query formula. Your a scholar.

I'm probably being a wee bit thick but grateful for some assistance. I am trying to create a formula in a form that works out the date midway between two dates e.g. 1st date 1 Jan 05 2nd date 1 jan 06 formula works out 1 Jul 06 (or thereabouts) and this is then stored in a field. Any ideas...

This may be a bit over the top but is there any way that I can produce a heirachical structure/functional diagram from personal information that I hold in a database. Ideally so that it looks like the equivelant produced in PowerPoint. Ta. Noel

Thanks after a bit of tinkering that worked quite well. Much appreciated.

I have a large personnel database in Access XP and have produced a query which groups by Regiment and then lists in rank order. What I would like to do is count the number of records in each rank, which then either needs to be listed below each rank or as a list at the end of the report...