• Here's one solution

    There is a Built-in Field named UserID (=User!UserID). This userID is the user's name that is passed through the reporting system when the report is run. This can either be saved in a hidden/internal variable and used in the query returning your main data set or used to populate another empNo variable after cross referencing your user table and the UserID variable.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.