Search results

Thank you for your help. I think I've got it now. Thanks again.

I'm getting things out of order here. Sorry, I'm new and trying! I had to delete my comment in between because it wasn't quite right. your answer of replace "datetable" with your tablename. doesn't make sense, since I am using query 1 as the data source, not a table. And then what I just...

arnelgp - Query 1 - didn't quite work, I kept getting an error 'At most one record can be returned by this subquery'. So I changed the '>' to a '<', and it seems to work. But I am getting weird results. DOS.............|Expr1.........|Expr2 10/8/2018 ....|10/5/2018...|-3...

Yes, I am counting the difference between the dates. Anything greater than 14 days is ok, anything less than 14 days I need to drop. Sorry if i wasn't clear. Thanks.

New to the forum here, but I have been working with Access for some time. Using Office 365 Pro Plus. I have a situation I cannot figure out. I have a table that contains dates of service, and I need to drop any date of service that is <14 days apart. A sample of some of the dates of service, and...