I dnt know much about reports.
i have a report which gives the details of Employees, my problem is
How to Search Records according to DepartmentNumber? where i put textbox for home department number?

I create one report , inside the report , Report Header has one textbox for asking Home Department number?

deptNumber has 10 digit text , I want to enter only first four digit by asking message box?

Can Somebody can help me in this problem?

PM me and send me your database. I can help you.

My code and query is now working.

Alright. Good luck on the rest of your database.