Recent content by SharonFinLV

[medal] [medal] [medal] [medal] [medal] [medal] [medal] Wow, PHV, I've never done a query like that with multiple tables and no join. [dazed] It looks like it's doing exactly what I wanted. Thank you so much - this is a huge lifesaver for several projects!! -SharonFinLV [medal] [medal]...

I have two tables: PAYEES OldID NewID PayeeName 10001 10001 Alan 20002 20001 Bob 30003 30001 Carl 40004 40004 Doug MEMBERS MembID MembAcct 10001 Xxx 20002 Yyy 30001 Zzz 40001 Vvv I want these results: OldID NewID PayeeName MembID...

I agree about the normalization, but to answer what I think is your question: If you want to show the records where Year1 is null AND Year2 is null AND Year3 is null (null for all three years, as opposed to any Year is null), then your Is Null criteria should all be on the same Criteria line in...

I do have other programs installed. How do I identify hacks... ...already installed? ...before I download/install? Good stuff and quick response, I love it! Thanks! -Sharon

I'm sorry, but what do you mean by "hacks"? -Sharon

When I try to use the Find in my Palm-based Visor Prism, it results in a Fatal Alert: TextMgr.c, Line:751, NULL source Sometimes it will start searching and listing matches, other times it goes directly to the error. Any ideas will be appreciated. Thanks! -Sharon