Data access in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function available to access 2 variables in a row heading and column heading and return a value? I would like to lookup a machine speed based on quantity run and one other variable

Thanks... Richard
 
Is it a Microsoft Access (a database application ) question?

Technically, there is no row headings in an Access Table.

If it is a Microsoft Access question, describe relevant details of your
Table, some sample data and what you are trying to get.

--
HTH
Van T. Dinh
MVP (Access)




rhaner said:
Is there a function available to access 2 variables in a row heading and
Click to expand...
column heading and return a value? I would like to lookup a machine speed
based on quantity run and one other variable.
 
Is there a function available to access 2 variables in a row heading and column heading and return a value? I would like to lookup a machine speed based on quantity run and one other variable.

Thanks... Richard
Click to expand...

If you're storing data in "column headings" - which is spreadsheet
terminology and NOT appropriate for a database - your table is
incorrectly designed.

If you have a fieldname ("column header") and a Primary Key ("row
header") you can use the DLookUp function:

DLookUp("[fieldname]", "[tablename]", "[rowheader] = " & 132)

will look up the value of [fieldname] for the row whose rowheader
field is equal to 132.
 
I am still setting up the database and essentially what I need to do is create and estimating database and the root of the database is misc machine speed tables. Most of the machines have two values needed to select a speed, how many pieces are to be run(more pieces the faster the net speed) and second how many pockets or feeding stations( the more pockets the slower the speed). I currently have the tables in Excel but I would like to figure out a way to put it in Access and design a form that customers can use on our web page

Thanks...
 
I am still setting up the database and essentially what I need to do is create and estimating database and the root of the database is misc machine speed tables. Most of the machines have two values needed to select a speed, how many pieces are to be run(more pieces the faster the net speed) and second how many pockets or feeding stations( the more pockets the slower the speed). I currently have the tables in Excel but I would like to figure out a way to put it in Access and design a form that customers can use on our web page.
Click to expand...

It sounds like a table with three fields would work: a field for
pieces and a field for pockets, in the same record as a field for
speed. You could then use a query with two criteria to look up the
speed. "Fields are expensive, records are cheap" - in a relational
database you are NOT limited to the two dimensions of a spreadsheet!
 
Back
Top