🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: ab.software.developers
Article #1064

Can Anyone Help? MS Access '97

#1064
From: Michael Blowers
Date: Thu, 29 Oct 1998 00:00
19 lines
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-mail

Show 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