Time Management

[Guest]

Here is my situation. I track a number of committees. I need to record meetings by location, committee, and meeting start and end times. In other words, our secretary will record a meeting by Committee A on January 22, 2004 at 13:00 until 14:00 in the Boardroom. The tables I have are
<table> atnMEETIN
<fields
CommitteeI
MeetingDat
StartTim
EndTim
LocationI

<table> refLOCATIO
<fields
LocationI
LocationNam
Capacit

<table> atnCOMMITTE
<fields
CommitteeI
COD
CommitteeNam
Activ
CreationDat
EndDat

I would like to create a function that checks the date and time before the secretary enters the meeting. This way, she will know if there is a conflict on the specific date/time and location

Thanks

Eri

 

[Michel Walsh]

Hi,



SELECT COUNT(*)
FROM atnMeeting
WHERE LocationID=ProposedLocation
AND Ending >= StartTime
AND Begin <= EndTime


returns the number of collision ( 0 implies no collision, it is ok),
assuming ProposedLocation, Begin and Ending are the parameters defining the
proposed meeting.




Hoping it may help,
Vanderghast, Access MVP

Here is my situation. I track a number of committees. I need to record

meetings by location, committee, and meeting start and end times. In other
words, our secretary will record a meeting by Committee A on January 22,
2004 at 13:00 until 14:00 in the Boardroom. The tables I have are:

<table> atnMEETING
<fields>
CommitteeID
MeetingDate
StartTime
EndTime
LocationID

<table> refLOCATION
<fields>
LocationID
LocationName
Capacity

<table> atnCOMMITTEE
<fields>
CommitteeID
CODE
CommitteeName
Active
CreationDate
EndDate

I would like to create a function that checks the date and time before the

secretary enters the meeting. This way, she will know if there is a
conflict on the specific date/time and location.