Search results

In the scenario VbaInet provided, the answer is yes Tuesday Oct. 18th would be the next call date. Not sure about all this stuff about collection or dictionary objects:confused: I think that stuff might be a bit beyond me. I was hoping for something simplier too:o Sigh....

I'm still racking my brains on this. I did try the suggested solution of changing from using DLookUp to using a recordset and that helped a bit, but unfortunately not much:( In response to the last 2 replies.... 1) I think the suggestion of using the DateDiff would only give me the number...

Thanks everyone for replying so quickly. Just a bit of clarification that might help determine what my options are: 1 - I am using a holiday table called tbl_Holidays that store just the holidays, not the weekends 2 - Each of my 50,000 records can have different last call dates and lead...

Hi I'm new to these forums, so please excuse any errors on my part: Basically, I have a query that is the Record Source for a report. The main query makes use of 2 sub-queries. In one of the sub-queries, it calculates the date of the next call to a customer based on the last call date and...