Help. I'm trying to write a database for vehicle reservations and I can't figure something out.
All vehicle reservations are going to have reservation dates (obviously). I have a table set up to list vehicles by USN # (like a VIN #), vehicle body type (pick-up, suburban, etc.), and a few other fields. I want to be able to type in the required dates, and body type and have the dbase show me what vehicles are NOT reserved during the required timeframe. Any advice? Thanks in advance.
sgtrock40
0
Newbie Poster
Recommended Answers
Jump to PostWell what programming language are you using? Are you just doing this straight in something like T-SQL (SQL Server 2000)?
Jump to PostWell, Microsoft Access isn't a database ;-). It's a GUI frontend for Microsoft JET Databases ;-).
Microsoft Access allows you to make "Forms" and "Reports" - something that a strict database engine wouldn't allow. Forms are the route to your answer: they use VBA as their language. Check out …
All 5 Replies
Tekmaven
258
Software Architect
Team Colleague
sgtrock40
0
Newbie Poster
Tekmaven
258
Software Architect
Team Colleague
suRoot
11
Posting Whiz in Training
sgtrock40
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.