Query - Lookup

[cbetts75]

Hi,

I have a table which holds various time stamps for a booking in process.

I'd like to create a query that only picks up a specific timestamp if another timestamp has not been updated

For example -

5 15:31
8 15:37

I'd like to only lookup timestamp 8 when timestamp 5 is not in the table

How would i go about doing this?

 

[Bilbo_Baggins_Esq]

Q: Are you looking to exclude time stamp 5 (15:31) and all time stamps less than that, or only that time stamp, (or are you looking to INCLUDE all time stamps greater than 5 (15:31)?

Q: Are these just examples, and are you really looking to exclude the "5"?

Q: Are there not more time stamps in the table?

Q: Does the time stamp also include the date, or only the time, or if the date is in another field, does the date play into it at all.

 

[cbetts75]

Q: Are you looking to exclude time stamp 5 (15:31) and all time stamps less than that, or only that time stamp, (or are you looking to INCLUDE all time stamps greater than 5 (15:31)?
If there is a timestamp for record 8 then I want the query to pick this up otherwise pick up timestamp number 5

Q: Are these just examples, and are you really looking to exclude the "5"?
Only exclude 5 when record 8 is available

Q: Are there not more time stamps in the table?
Many more timestamps

Q: Does the time stamp also include the date, or only the time, or if the date is in another field, does the date play into it at all.
Date and Time in one field