populate fields based on a date/time range in another table

[afaust]

Hi,
I have two tables, one with oceanographic data and a date/time stamp and one with location data and a date/time stamp. None of the date/time stamps match exactly and I want to match up the location data to the oceanographic data using a +/- 30 second time interval.

I don't know how to use an interval of time or write the code for that. If anyone can help me a little, I would really appreciate it.

Thanks,
Abby

 

[DCrake]

Have a look at creating a field in a query that has the date/time rounded to the nearest minute be it up or down. Then do a comparison on them.

 

[afaust]

that is a really good idea...sometimes we overthink i guess...

I will let you know how it goes

 

[afaust]

Actually, that won't work for what I have to do because they want the time to match to the closest time that the other table has...and when I round the time in the Location table, I get several records with one time stamp.

Thanks for the advice though. I have been looking at some code for doing this, it is just a little bit out of my comprehension level...

Abby