Hi,

I am having an issue with a DLast function I am using for a field's control source. The field is a combined Date/Time field and the DLast appears to only be looking at the time so I have a comment inserted at 1100am Feb 18th that is showing rather than a comment left Feb 19th at 900am. Is there a way to fix this without changing the table structure to a separate date / time field?

Here is the DLast func I have: =DLast("[InsDateTime]","Comments"," [CallBackID] = " & [CallBackID])

Thanks,
Robby

Hi

Try DMax() instead of DLast()..........

Yup that worked man. Thanks. I have to get a list of all these D functions. Very handy when you use the proper one.!

Robby

LOL - yep, using the right one works wonders........glad you got it working