Using User!UserID in a query

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  February 12, 2014 at 12:58 pm

  #396260

  Hi,

  I'm trying to use the logged in user User!UserID in a where clause of a query to take only logged in users data

  I tried ... where username = Right(User!UserID, len(User!UserID) - 9) The left side is the domainname

  Any Ideas would be great

  Thanks

  Joe