earliest and latest date/time per day

M

mike

I have some data that is date/time.
I need to be able to pick out the earliest time stamp and the latest
time stamp for a particular date(s). What would be the query to have a
report show only those two date/time criteria yet not show all the
other time stamps in between?
access 2000 on xp.
thank you.
 
P

Pieter Wijnen

select min(a.timestamp), max(a.timestamp) From mytable ?

Pieter

I have some data that is date/time.
I need to be able to pick out the earliest time stamp and the latest
time stamp for a particular date(s). What would be the query to have a
report show only those two date/time criteria yet not show all the
other time stamps in between?
access 2000 on xp.
thank you.
Click to expand...



--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP need time sheet/card calculate hours worked 1
Date Filter 5
earliest date? 3
Grouping by Date when the Field has a Time Stamp 8
date and time field 4
Insert date-time value using SQL? 2
Short date report prompts for long date results 2
changing a date based on the time of day 1

Top