finding how many values of a user in a table that the user is not shows in the table

[Chipcom]

Hi

I need to find how many values of a user in a table that the user is not shows in the table but he has relationship to the table.

I know that I need to use the Dlookup function but I don't know how to do syntax to it.

Can you please help me?

 

[The_Doc_Man]

Your question is unclear.

My first guess is that if the user is not in the table, DCount will be zero.

So you must want to form a JOIN query with that table and a table where the user WOULD be found. You can do a DCount or DLookup on a query just the same way you would do it for a table.