jakś pętla ?

Article View: pl.comp.bazy-danych.msaccess

Article #137354

Back to pl.comp.bazy-danych.msaccess Previous Next

#137354

From: LeszekN
Date: Thu, 24 Nov 2016 08:40

30 lines
1692 bytes

Witam
Mam jakąś pomroczność ;)

tabela tblKlasy
IDpoz, KGOD, KGDO
dane w tabeli
1 0   99
2 100 130
3 131 145


potrzebuję sprawdzić do którego rekordu z tabeli tblKlasy pasuje zmienna s (wartość zmiennej np 121) 
w tym przypadku powinna pasować do rekordu 2 bo wartość jest pomiędzy KGOD 100 a KGDO 130

While Not rs.EOF
If s > rs!KGOD Then
    If s < rs!KGDO Then

'tutaj robimy co chcemy jezeli pasuje
   Else
   End If
Else
End If
rs.MoveNext
Wend 


nie mam pomysłu jak to sprawdzić 
pozdrawiam
Leszek

Technical Details

Message-ID: <3c7634dc-aecb-46c3-bf90-b6aa15eb2abd@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!n6no557098qtd.0!news-out.google.com!j8ni2281qtc.0!nntp.google.com!n6no557093qtd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Received: by 10.36.22.11 with SMTP id a11mr134679ita.7.1479976859448;        Thu, 24 Nov 2016 00:40:59 -0800 (PST)
X-Received: by 10.157.8.134 with SMTP id 6mr37065otf.17.1479976859401; Thu, 24 Nov 2016 00:40:59 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!n6no557098qtd.0!news-out.google.com!j8ni2281qtc.0!nntp.google.com!n6no557093qtd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Thu, 24 Nov 2016 00:40:59 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=193.192.179.172; posting-account=i0RtOwoAAABRI8EWUf_BQOpbS6yj4J_N
NNTP-Posting-Host: 193.192.179.172
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3c7634dc-aecb-46c3-bf90-b6aa15eb2abd@googlegroups.com>
Subject: jakś pętla ?
From: LeszekN <leszeknowak@wp.pl>
Injection-Date: Thu, 24 Nov 2016 08:40:59 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit