Howdy...
I have a select statement which queries a table and prompts the user to input the name they are searching for. Now the user will put in first (space) lastname but I am storing the names from active directory so they are first.last name.
Is there a way to use the name which has been put in to pull the actual name out? My current code is below - thanks
Code:
SELECT Table.sUser, Table.Activity, Table.Hours, Table.Project, Table.[Task Date], Table.Description
FROM Table
WHERE (((Table.sUser) Like [Enter Name ] & ".") AND ((Table.Approved)=False));