Recent content by Jekyll

Thanks. That'll sort out the stop condition. Just a couple of related questions though.<br><br>Is the SQl just entered direct into the Query SQL view?<br>If the loop is coded into the query, then is there a need for a macro to run it? <br><br>Is the loop code more than just the code used to do a...

Just in addition,<br><br>I'm guessing (literally) that I'll be using something like<br><br>While val &gt; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(instead of counter)<br><br>and <br><br>Wend ' End While loop when Val = 0<br><br>----------------------------<br><br>But...

I need to query a column for a variety of numbers, and the way I am hoping to do it is to setup an Access Macro and a loop asking for numbers (through an Input Box).<br><br>I then want the Macro to stop asking for numbers when I key in a Zero (for example).<br><br>So I need to setup a VB loop...

Thanks for the suggestion.<br><br>Unfortunately it still won't recognise the individual numbers. Any other ideas?<br><br>Might it be to do with the definition of the function?<br><br>Or is it more likely to do with the punctuation required for a number datatype?<br><br>Cheers,<br><br>Jekyll.

This is a follow up query to a problem I have been working on for a while now. (Multiple Query in a column I think I called it)<br><br>What I have is a column of numbers representing machines, ranging from 1-999. What I need to be able to do is to select non-sequential samples of these numbers...