Parsing a Timestamp

[Scottie]

I want to be able to sort a timestamp and then query it every 30
minutes. How do I accomplish this? I am thinking that my first
hurddle is to parse it out the timestamp. Any help would be greatly
appreciated.

Thanks. Scott

 

[Guest]

Post an example of your data and what you want for results.

 

[Scottie]

PreloadId PkgID StopId SpaTime RouteName SLIC CarNum
629 485 156 5:14:22 AM 50A 9876 888888
629 60926 156 5:08:46 AM 50A 9876 888888
629 61308 156 5:18:12 AM 50A 9876 888888
629 61237 1236 5:16:43 AM 50A 9876 888888
629 417 156 5:16:32 AM 50A 9876 888888
629 5405 928 5:16:07 AM 50A 9876 888888
629 61161 156 5:14:43 AM 50A 9876 888888
629 5106 2117 4:42:29 AM 50B 9876 999999
629 858 88 4:42:55 AM 50B 9876 999999
629 262 72 4:44:04 AM 50B 9876 999999
629 48159 618 4:45:00 AM 50B 9876 999999
629 2615 33 4:45:18 AM 50B 9876 999999
629 7950 789 4:48:53 AM 50B 9876 999999
629 4185 88 4:50:37 AM 50B 9876 999999
629 49048 2117 4:29:12 AM 50B 9876 999999



The timestamp doesn't show the date. Must be an Access to Excel export
conversion. It shows when I highlight the cell in Excel. Each unique
StopID = 1 Stop. I want to be able to query the number of Stops every
30 minutes. This is just a small sample, so I can provide more if
necessary.

50A would have a total of 3 stops (156, 928 & 1236) and 50B would have
a total of 5 stops (33, 72, 88, 618, 789 & 2117)

 

[Joseph Meehan]

PreloadId PkgID StopId SpaTime RouteName SLIC CarNum
629 485 156 5:14:22 AM 50A 9876 888888
629 60926 156 5:08:46 AM 50A 9876 888888
629 61308 156 5:18:12 AM 50A 9876 888888
629 61237 1236 5:16:43 AM 50A 9876 888888
629 417 156 5:16:32 AM 50A 9876 888888
629 5405 928 5:16:07 AM 50A 9876 888888
629 61161 156 5:14:43 AM 50A 9876 888888
629 5106 2117 4:42:29 AM 50B 9876 999999
629 858 88 4:42:55 AM 50B 9876 999999
629 262 72 4:44:04 AM 50B 9876 999999
629 48159 618 4:45:00 AM 50B 9876 999999
629 2615 33 4:45:18 AM 50B 9876 999999
629 7950 789 4:48:53 AM 50B 9876 999999
629 4185 88 4:50:37 AM 50B 9876 999999
629 49048 2117 4:29:12 AM 50B 9876 999999

Is that time field an Access date-time data type or maybe text?

 

[Scottie]

The time field is an Access date-time data type.

 

[John Vinson]

The time field is an Access date-time data type.

A Date/Time value is stored as a Double Float number, a count of days
and fractions of a day since midnight, December 30, 1899. E.g.

?Now;CDbl(Now)
5/9/2006 10:40:31 AM 38846.4448032407


John W. Vinson[MVP]