Recent content by Gordoni

Many thanks for the welcome Rabbie. The "fun ???" is in finding ANY solution that works. ...but I do enjoy trying. Thanks again Gordon

To KenHigg and nanscombe Hi Your table tip worked a treat Ken - Don't know why I didn't think of this - Must be getting older than I thought. I'm not a programmer nanscombe but your "case" statement appears to work something like "if-then-else". I'll certainly be having a play with it. That's...

Many thanks Ken - I'll work on that. Gordon

Hi Within a query I've been trying to calculate a zodiac sign from a DoB field. Am assuming that an array would solve the problem but arrays have been a bit of a long-time mystery to me. eg: Dob = 12-Jul-1947, Zodiac sign would be Cancer (June 21 to July 22). Can anyone point me in the right...

Hi I'm a long term user of Access (started mid-90s) but, sadly, not a programmer. Well into my 74th year I've spent the last three years in and out of hospital. That's all I'll say on that except that I'm looking forward again and hoping for the best. An electrician by trade and my lifelong...