051119

Sorry, I've been a nitwit and found a better way of solving my problem!

I have a query which throws up a number, and I want to find values that fall within that number, plus 200. Basically, if the query throws up 1000, I'm after 800 to 1200. I've tried adding Between ([Query]![Val1]-200) And ([Query]![Val1]+200))); to the bottom of a query with no success. I honestly can't think of any other way to do this. Does anyone have any ideas?

That's great, thanks very much!

Hi, I have the following query select vb_user.username as "Username", vb_userfield.field14 as "Mileage" from vb_userfield join vb_user on vb_user.userid = vb_userfield.userid order by vb_userfield.field14 desc[/Code] and I want to ignore any results from the username [i]Paul[/i] / userid [i]1432[/i] (they are the same thing). Can anyone advise how to do this, I've tried adding [i]where !=[/i] but this doesn't seem to work? Thanks

Nevermind, I've got it thanks! I used DateAdd in Access!

Sorry, didn't realise there was a difference! If anyone can help I would be very grateful, I've been racking my brains for hours over this!

Thank you ever so much for your reply! Access throws up this error though

Hi all, I've got 2 tables as below: stops Stop_name RouteNumb Order Min_from_start routes RouteNumb Start_time In essence, Start_time contains the time the bus sets out on its journey, and Min_from_start is how many minutes from the first stop the bus is (eg. so if Start_time is 09:00 and Min_from_start is 14, then I'm looking for 09:14). Can anyone please help me find an SQL query to calculate this? So far I've got SELECT stops.Stop_name, stops.Min_from_start, routes.Start_time FROM routes INNER JOIN stops ON Routes.RouteNumb = stops.route WHERE (((stops.route)="12")); Which shows the info but not the times. Thank you so much!