Rich,
Thanks, but what is the "IsDate"?
Is that what is checking to see if date is present?
I think I might understand the flow! But it didn't work in A2K is what you wrote 97 specific?
And is it proper to place in a query?
Rich may have been in a bit of a hurry. Try this slight correction:
IIf(IsDate([EndDate]),DateDiff("d",[EndDate],[BeginningDate]),DateDiff("d",[BeginningDate],Date()))
Assuming your field names are correct, this should work in Acc2k.