I have 2 tables with a 1 to many join and the key id is the join. The many table has a date and I would only like the record with the most recent date to be joined if there are more than one. I built a query where the date field criteria is max([date field]). That field could be Null but I am not checking for that, could that be the issue?
Appreciate any assistance!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.