Search results

Agreed - need to verify results. The flow data are pretty complete in terms of dates/times, though, so I'm comfortable with using that as a superset.

SQL view says LEFT join. Thanks for pointing that out. Again although I have been using Access for 20+ years, I've only been doing so in a basic way. Today was the first time I've looked at SQL view. I used to let my techs and grad students do the heavy lifting with Access; paying the price now...

I was using an inner join. Modifying it to a join with arrow pointing from Flow_DateTime to Count_DateTime (presumably an OUTER join [RIGHT join?]) fixed the problem - many thanks MarkK. Will try to post SQL next time. Again, new to the forum so have some learning to do.

Folks – New to the forum, so please bear with me. I’m looking to do a simple merge of two tables containing date and time (MM/DD/YY HH:MM) information. The first table has hourly records of river flows: Flow_DateTime Flow 1/1/22 0:00 13400 1/1/22 1:00 13900 1/1/22 2:00 14100...

New to the forum; intermittent Access user for 20+ years, never highly skilled at it. Retired scientist.