whoops!!!
I'm sorry!!

I'm back at work now and it seems that the problem may be related to using private data sessions....does that seem reasonable?

I also have a timer in this app and it was keeping certain tables open between events. I've changed it now to close those tables and reopen them only when it needs them. That seems to help. Now my requery is giving the results I expected....now I'm checking for ripple effects to not leaving those tables open.

Do you think that private data sessions could be the reason?
Someone mentioned adding a FLUSH. If I'm closing the tables I wouldn't need the FLUSH, would I?

Rick


>>Nick,
>>It's actually a good question, but in this case I dodge the bullet....
>>the field's name is OrderItems.Close_Date
>>
>>I'll be gone for the weekend and will be back at this Monday morning.
>>
>>Rick
>
>He-he. And it was not even Nick :)