I have a table where i store the records; one of the field is case logged in user and this fields captures data from the environ("username") using VBA. I am writing a query to retrieve the records based on user currently logged to the system and i am unable to do so?
Can any suggest how to do it in access without using vba? something like
select * from [table name] where fieldname = currentloggedinuser;
thanks,