another question from Newbie to Access

  • Thread starter Thread starter Mark \(InWales\)
  • Start date Start date
M

Mark \(InWales\)

Hello All

In Excel I can use Index & Match to return a value from a 10 row 5 column
grid. How do I do this in Access please.

Many thanks

Mark (InWales)
 
hi,
Access doesn't have grids. it has tables. you enter
criteria in the query's criteria grid to find matches.
 
Hi Mark,

You're asking an Excel question even though you think you're asking an
Access question. If you require that someone know another app to understand
your question ....
 
In Access, your data will be stored in a specific column of a specific row
in a table, so you would retrieve it using SQL or perhaps a DLookup()
function (which is also based on SQL syntax). Something like:

SELECT ColumnName FROM TableName WHERE IdentifyingColumnName =
IdentifyingValue

or

=DLookup("ColumnName", "TableName" "IdentifyingColumnName =
IdentifyingValue")

Where 'ColumnName' is the name of the column containing the particular value
you want to retrieve, 'TableName' is the name of the table,
'IdentifyingColumnName' is the name of a column (or the names of a
combination of columns) containing values that uniquely identifies a row,
and 'IdentifyingValue' is the value (or combination of values) to be
matched.
 
Thanks Brendan

Mark (InWales)
Brendan Reynolds said:
In Access, your data will be stored in a specific column of a specific row
in a table, so you would retrieve it using SQL or perhaps a DLookup()
function (which is also based on SQL syntax). Something like:

SELECT ColumnName FROM TableName WHERE IdentifyingColumnName =
IdentifyingValue

or

=DLookup("ColumnName", "TableName" "IdentifyingColumnName =
IdentifyingValue")

Where 'ColumnName' is the name of the column containing the particular
value you want to retrieve, 'TableName' is the name of the table,
'IdentifyingColumnName' is the name of a column (or the names of a
combination of columns) containing values that uniquely identifies a row,
and 'IdentifyingValue' is the value (or combination of values) to be
matched.
Click to expand...
 
Back
Top