Search results for query: *

Magic, worked 1st time. Thanks ph. That's this database essentially finished now. I'll try and repay this good forum karma In a couple of years when Im qualified and I actualy now what Im doing : )

Thanks PH, that looks good. I won't be able to try it until later today, but i'll lt u know how it goes.

Hello All I'd appreciate some help with a (for me) pretty complicated query Im attempting. Im trying to achieve 1 answer if the source is less then 7, and another answer if it is greater. I've been searching through archived posts and picking up tips to the extent that I think im in the right...

If you give me the SQL I'll test the code you're talking about in my existing query if you would like.

Thanks everyone. The last SQL Bob put up as worked for me. Now Im going to try and piece it all together and try to appreciate how and why it works. I'll try to take all your points about the inconsistant field names/formating. Now I know my query works im going to try and improve it as you...

Here's the SQL SELECT Bookings.Start_Date, Bookings.End_Date, Bookings.[Car Registration], [start Date] AS Expr1 FROM Bookings WHERE ((([start Date]) Between [Start Date] And [End Date])); I hope that's a little more illuminating

Thanks for the replys everyone. I don't think I've done a good job explaining what I want. I want to set up a query that a user would open by clicking a link on switchboard ("Check for availability of cars for rental") that would then open a this query. As soon as this Query opens I want them...

Hello all I was wondering if anybody could help me out with a query problem I've been having. I've been trying to use a query to display a list of available cars for a given start and end date entered by the users. I have found some guidance to make an attempt but it isn't working. The text in...