Vlookup

[abrahamgluck]

I want to have like a vlookup in access any reference how it can be done in access, or an example to paste in, I'm really new to access...


Table A Column X Column Z
Table B Column X Column Z

let me speak excel language for purpose of understanding my needs

I want this formula to be in column Z on Table A "=VLOOKUP(Column X, Table B! Column X: Column Z, 2)"

BUT in column X in table B their is a lot of duplicate values I want if any of those returns False in column Z it should return true (yea true) in column z on table A

[aytee111]

In Access lookups on tables are not used, they cause multiple problems down the road. When joining a primary key of table 1 to a foreign key on table 2, use the Relationships window. Then in queries/forms/reports, join the tables by linking.

Let us know what these columns will contain and we can help design the correct table structure.

[Minty]

You would use a query with a join. Add the two tables into your query view.
Drag field X in table A to join to field X in Table B.

Select some other fields to display.
See if that provides the joint records correctly.

Then add some criteria to restrict the displayed items. If you get stuck post up a picture of the query and what you are trying to get to in terms of results.

[abrahamgluck]

I have duplicates on table B but not in table A
I want to see it like in table A but one field from table B (true or false field) but not the duplicates only all one and if there is a an example of true and false for the same record then true should be the one coming in

[aytee111]

To find duplicates, use a query. There is a query wizard which will do this for you. There is no need to keep the true/false on the table, you can refer to the query when you need that information.

[abrahamgluck]

Excel formula


=COUNTIFS(OtherSheet!A:A,A1,OtherSheet!B:B,TRUE)>0


Would someone have a solution to use a function like this in Access? (I have subdatasheets I'm not sure if Queries will be a solution for me)

[Minty]

Queries will work on any linked tables, provided they have a common field.
What have you tried?

Running a Select query will not break or delete anything, just play with some simple ones to get an idea.