I want to search for all records entered on a specific day, but I want the query to prompt me for that date and also I want it to have some sort of mask format so the user can't make any mistake in the date he's entered.

example: my format is mm/dd/yy I want the prompt box to have that exact format.

Is it possible?

I would create a pop-up box and tie that form into the query criteria. Type a text message that specifies the format in which the date needs entered, and/or create an input mask. You will also have to define it in the query parameters.

I've tried to type the exact same format and I get no results, any ideas?

Opinions differ on this subject, but I would recommend NOT putting an input mask on your date fields. Instead make a validation rule to ensure that your data is in a valid time frame. You can format the field to display mm/dd/yy no matter what is typed originally.

HTH,
David R