Excel MATCH formula and Access Equivalent

[maeyks]

Hello,



May I know what is the equivalent formula of MATCH (excel) in Access?
Thank you.

[CJ_London]

match returns a relative position in excel, there is no real equivalent in Access (which is not a 'bigger' excel) since there is no concept of row numbers (or column numbers for that matter) - data is returned in random order unless an order is set by the developer.


Perhaps explain what you are trying to do and a solution can be selected.

[maeyks]

match returns a relative position in excel, there is no real equivalent in Access (which is not a 'bigger' excel) since there is no concept of row numbers (or column numbers for that matter) - data is returned in random order unless an order is set by the developer.


Perhaps explain what you are trying to do and a solution can be selected.

Thank you. I would like to personally explore ACCESS and the similar work it can provide as that of EXCEL. Right now I have a database wherein I selectively get data and its details.

I was really hoping that Access can also be used to perform this function.

Scenario is:

1. I have database A
2. If I pullout a code (not necessarily ID number) it will return the details based on database A

Help.

Thank you.

[CJ_London]

rather a vague question so not possible to answer in detail. so a couple of pointers


1. access is not excel
2. in excel data tables are 'short and wide'. in access, they are 'tall and thin'. An example. in excel you would typically have say invoice details in one table e.g. customer, invoice number, date, item, quantity, price, value. In access this might be three tables, customer, invoice header, invoice detail. So customer is entered once (in excel, for every row), invoice header, once per invoice and invoice details
3. in access you use queries which have a number of component parts including - SELECT, FROM, WHERE so a query might be

SELECT *
FROM myTable
WHERE somefield=avalue

this is the nearest to match

[maeyks]

rather a vague question so not possible to answer in detail. so a couple of pointers


1. access is not excel
2. in excel data tables are 'short and wide'. in access, they are 'tall and thin'. An example. in excel you would typically have say invoice details in one table e.g. customer, invoice number, date, item, quantity, price, value. In access this might be three tables, customer, invoice header, invoice detail. So customer is entered once (in excel, for every row), invoice header, once per invoice and invoice details
3. in access you use queries which have a number of component parts including - SELECT, FROM, WHERE so a query might be

SELECT *
FROM myTable
WHERE somefield=avalue

this is the nearest to match

Well this is rather new to me, the SELECT, FROM, WHERE Query in Access.
I will post questions in the future if I have any more concerns

Thank you very much.