Setup a query

[marrisa_o]

Hi

My fren laptop can run a query which has been setup a query but mine's not working. below is the field which is need to be added to the layout

can anyone assist.

i attached a file

[JoeM]

What do you mean you cannot run it?
Do you get some sort of error or unexpected results?

[June7]

What does 'not working' mean - error message, wrong results, nothing happens?

Why are you doing a self-join?

What field needs to be added?

What is the primary key field?