Search results

Right, I got that... but my quiry not stoping people hiring the same car out to someone WITH the same date. I'm assuming its an IFF statement I use which looks at the date hired for?

Hi, Ok what i'm trying todo in the query is add two dates togethere so date car hire: 01/01/2008 date care gets returned:02/01/2008 Date car is returned: 3/01/2008 - adding the first two fields. The day and month is fine just the two years are adding and keep giving 2016! AND, i cant...

K, i'm doing internet reading. I've sort got the date working however the year is wrong. expr1: CDate([First_day_of_hire])+CDate([Last_day_of_hire]) - it'll get the day and month correct just the year not working!

return date: tbl_hire!First_day_of_hire+tbl_hire!Last_day_of_hire - the code i'm using for the return date however its adding up the whole lot not the first bit :(

yeah, like the information, however how do you do that? lol, I cant seem to work that out... or is it like a text linked to the query?

Hi Guys, I’m making a database which is used to hire cars to customers. What I’m having problems is that I want the user on the application to have a list of all the cars free for a certain date. I know that if I do in a query I can get the result of free cars. But the problem is can I pass...