This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » Find next "opening" in appointment table of bookings but no openings.

Find next "opening" in appointment table of bookings but no openings.
Mark Szlazak Member Since: 26 Jan 2009 Posts: 1	Posted 26 Jan 2009 09:20:14 I have to work with a MS Access appointment table that only has records of booked appointments. There is an [Date] field for the date of the appointment, a [Time] field for the time of the appointment and a [Length] field for appointment length. So an appointment starts at [Date] + [Time] and ends at [Date] + [Time] + [Length]. If I want to find the next available 1 hour opening starting 24 hours from the present and on ward, I would need a way query the appointment table and check for any 1 hour or more "gaps" between consecutive records, assuming a table ordered by time. What kind of sql string(s) would be need to accomplish this? Thanks. I have to work with a MS Access appointment table that only has records of booked appointments. There is an [Date] field for the date of the appointment, a [Time] field for the time of the appointment and a [Length] field for appointment length. So an appointment starts at [Date] + [Time] and ends at [Date] + [Time] + [Length]. If I want to find the next available 1 hour opening starting 24 hours from the present and on ward, I would need a way query the appointment table and check for any 1 hour or more "gaps" between consecutive records, assuming a table ordered by time. What kind of sql string(s) would be need to accomplish this? Thanks.

Find next "opening" in appointment table of bookings but no openings.

Mark Szlazak
Member

Since: 26 Jan 2009
Posts: 1

Posted 26 Jan 2009 09:20:14

I have to work with a MS Access appointment table that only has records of booked appointments. There is an [Date] field for the date of the appointment, a [Time] field for the time of the appointment and a [Length] field for appointment length. So an appointment starts at [Date] + [Time] and ends at [Date] + [Time] + [Length].

If I want to find the next available 1 hour opening starting 24 hours from the present and on ward, I would need a way query the appointment table and check for any 1 hour or more "gaps" between consecutive records, assuming a table ordered by time.

What kind of sql string(s) would be need to accomplish this?

Thanks.

I have to work with a MS Access appointment table that only has records of booked appointments. There is an [Date] field for the date of the appointment, a [Time] field for the time of the appointment and a [Length] field for appointment length. So an appointment starts at [Date] + [Time] and ends at [Date] + [Time] + [Length].

If I want to find the next available 1 hour opening starting 24 hours from the present and on ward, I would need a way query the appointment table and check for any 1 hour or more "gaps" between consecutive records, assuming a table ordered by time.

What kind of sql string(s) would be need to accomplish this?

Thanks.

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!

Forums

Find next "opening" in appointment table of bookings but no openings.

Reply to this topic

Live Support

On Sale

DMXzone Tabs

Advanced HTML Editor 3

Image Gallery Add-on

File Manager Add-on