Searching particular Detail IN Report (1 Viewer)

[Pioneer]

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?

 

[tarcona]

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

 

[Pioneer]

thnks

My code and query is now working.

 

[tarcona]

Alright. Good luck on the rest of your database.