•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,563 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,719 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1746 | Replies: 0
 |
•
•
Join Date: Mar 2006
Location: Nairobi, Kenya
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Help with data validation on booking trip application... Hi everybody,
I hope you can help me tackle this little pb.
OK, I need to create an access database aimed at booking salesmen trips to different cities (NY, Dalllas, Washington, Miami). Basically, I'm using 4 fields: Saleman, Location, Star Date and End Date. Now, I need to create a validation rule that will prevent a salesman to register for a date and location that has already been assigned.
Upon insertion of a new record, I will need to compare the date range (let's say I'm inserting John Smith, New-York, start: 04/01/2006 end: 04/07/2006) against other previously entered date range for the same location (Lets' say John Doe, New York, start 04/08/2006, end 04/20/2006) so that I don't have two guys booked for the same location within the same period.
The logic/validation rule should check other location fields date ranges and prevent a new record to be created if the dates are overlapping.
Any help /ideas would be greatly appreciated.
Thanks in advance for your time :cheesy:
Jean-Yves
I hope you can help me tackle this little pb.
OK, I need to create an access database aimed at booking salesmen trips to different cities (NY, Dalllas, Washington, Miami). Basically, I'm using 4 fields: Saleman, Location, Star Date and End Date. Now, I need to create a validation rule that will prevent a salesman to register for a date and location that has already been assigned.
Upon insertion of a new record, I will need to compare the date range (let's say I'm inserting John Smith, New-York, start: 04/01/2006 end: 04/07/2006) against other previously entered date range for the same location (Lets' say John Doe, New York, start 04/08/2006, end 04/20/2006) so that I don't have two guys booked for the same location within the same period.
The logic/validation rule should check other location fields date ranges and prevent a new record to be created if the dates are overlapping.
Any help /ideas would be greatly appreciated.
Thanks in advance for your time :cheesy:
Jean-Yves
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access apple application application acceleration australia breach broadband code combo computing core crime daniweb data data protection data transfer database drive dropdownlist forensics government hard hardware hitachi immigration internet ip linux mac microshaft microsoft microsoft sharepoint module ms net news pro processor reuse security services storage terabyte us army visa web wikipedia
- Data validation- want only Int's (C++)
- Data From C++ GUI to Excel/Notepad, Application Trouble (C++)
- Using Visual Fox Pro data tables in asp.net application (ASP.NET)
- Data validation (C++)
- Forms Authorization/ Authentication using asp .net and vb .net (ASP.NET)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Creating a form that display a continuous collection of pics
- Next Thread: top 10 with a twist
