[Find within/between two values]

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

[Find within/between two values]

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?

[Exclude from MySQL SELECT]

That's great, thanks very much!

[Exclude from MySQL SELECT]

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

[Additions in SQL]

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

[Additions in SQL]

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!

[Additions in SQL]

Thank you ever so much for your reply!

 

Access throws up this error though

Syntax error (missing operator) in query expression 'routes.Start_time + INTERVAL stops.Min_from_start MINUTE'[/Quote]

 

I've tried playing around with it a bit but can't work out what it's after. Would be grateful for any help!

 

Regards

[Additions in SQL]

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!