Dear All,
The following is the query.
SELECT TenentList.[Tenent's Name], TenentList.[Unit No], TenentList.Status, TenentList.[Authorization Letter], TenentList.[Open Date], TenentList.[Close Date], TenentList.[Authorization Letter], TenentList.[Authorization Letter].FileData, TenentList.[Authorization Letter].FileName, TenentList.[Authorization Letter].FileType, TenentList.Remarks
FROM TenentList
WHERE (((TenentList.[Tenent's Name])=[Enter the tenent's name]));
I want to enter the three possible characters for tenent's name then it pull all records that contains first three character.
Please modify my query in where clause so that i can pull the record.
Note : criteria will be in query design view.
Thanks..
Rgds,
aligahk06