New to Access. Expression question

[Kirstee]

Hello everyone,



I've been working with Access for about a month now and, I'm learning new things everyday. This forums has been a great help to me.

I'm kind of stumped right now. This question might seem simple enough but for the life of me, I cannot find a resolution to it. Here goes

I have one table very similar to this below

tblInstallations

IDpk	userID	applicationID	TransferLink
1	5	1	0
2	6	1	0
3	7	2	2
4	8	1	1

I created a split form which displays the datasheet on bottom.
Is there a way to only display the records that match in ID and TransferLink? So the output would look like this:

ID	userID	applicationID	TransferLink
2	6	1	2
1	5	1	1

Only shows the records that have matching value in ID and TransferLink.

This seems like it should be easy, I just cant figure it out.

Thanks in advance for any help.

[orange]

You may get some ideas from this thread and sample database.
It may be applicable, but you know your data and requirements. It doesn't use split form as such, but emulates same quite effectively.
Good luck.

[Bulzie]

So you only want to show a record if the ID value is anywhere in the TransferLink column? If there is more then one match you want to show all of them?

[Nikhil.bbz]

select IDpk,userid,applicationid,transferlinkid
from tblinstalation where
idpk=transferlinkid

[Nikhil.bbz]

if any other problem please contact on 18662172188

[Bulzie]

Using Query Designer, create a query with only transferlinkid field, use Totals/Groupby to get unique values, save query.
Create 2nd query, include table above and new query you just created. Link ID field from table to TransferLinkID field from query. Add first 3 fields(not TransferLinkID) from table and the TransferLinkID field from query to this 2nd query and run it.