Divisible Query

Results 1 to 3 of 3

Thread: Divisible Query

  1. #1
    Join Date
    Dec 1969

    Default Divisible Query

    Hi guys!,<BR><BR>How can I check if a particular number entered into a form is divisible by a variable being stored in the database. e.g if the variable in the database is 2 and the number entered is 10 then the process occurs otherwise it returns an error stating that the number entered is not divisible by 2.<BR><BR>Someone suggested MOD. What is that and how do I use it?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Divisible Query

    x = 10<BR>y = 2<BR><BR>If x mod y = 0 Then &#039;it&#039;s divisible<BR>...<BR>Else &#039;it&#039;s not divisible

  3. #3
    Join Date
    Dec 1969

    Default MOD.

    Read the documentation. It&#039;s an operator:<BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vbscripttoc.asp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts