Search results

Genius !! I crosstab’ed the min date and time for each week for each fish, then added in new columns and used update queries to populate these with the km value for that date and time for each fish. Took one week from the next to give the result. Many thanks baldy.

The table holds over a million records, each record is fish specific 'Tag ID' (43 different fish) and holds the 'date and time' and the position of the fish in 'km', km's from the downstream limit of the study area, that each fish was detected. There are multiple records for each fish each day...

Thanks for that link Paul. So the first and last functions don't work.... Any other way around it? Min and Max aren't appropriate. cheers chris

First and Last Functions in Crosstab Query I’m using Access 2003. I have some fish tracking data that I’m trying to interrogate using crosstab queries. The table ALL DATA contains the fields; ‘Tag ID’, ‘Date’, ‘Time’, ‘Date and Time’, ‘km’ and ‘Rec Name’. I want to find out where each fish...