Article View: ab.software.developers
Article #1064Can Anyone Help? MS Access '97
From: Michael Blowers
Date: Thu, 29 Oct 1998 00:00
Date: Thu, 29 Oct 1998 00:00
19 lines
1232 bytes
1232 bytes
Can anyone help?
MS Access �97: -
I have set up a table as example below:
Design Height 100Wide 200Wide 300Wide
26 100 10 20 30
26 200 20 30 40
26 300 30 40 50
I have created a form where a user enters the design as 26; height as 200;
width as 200
I have created a query, which searches for the design & height entered, but
from this how can I extract the number 30 from the 200wide field based on
the width a user has entered?
All responses gratefully received.
Technical Details
Message-ID:
<3638fba6.0@news.albatross.co.uk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10f2ee,1dad23c459da5f08,start X-Google-Attributes: gid10f2ee,public From: "Michael Blowers" <mblowers@albatross.co.uk> Subject: Can Anyone Help? MS Access '97 Date: 1998/10/29 Message-ID: <3638fba6.0@news.albatross.co.uk> X-Deja-AN: 406521124 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 X-Trace: news.giganews.com 909712723 195.16.65.4 (Thu, 29 Oct 1998 19:58:43 CDT) Organization: A customer of Albatross Networks Ltd. NNTP-Posting-Date: Thu, 29 Oct 1998 19:58:43 CDT Newsgroups: ab.software.developers