Link to home
Start Free TrialLog in
Avatar of lheroux
lheroux

asked on

Find and replace

The db has fields where dates must be entered in mm/dd/yyyy format. Please tell me how to do that using find and replace. I have tried __/__/____ and null and various forms of __/__/____ using 9's and 0's in a query with the same error message: "Microsoft Access finished searching the records. The search item was not found." I would like to avoid the need to enter each date separately or using a copy/paste. Your assistance would be greatly appreciated. Thank you.   Lyn
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lheroux
lheroux

ASKER

Thank you.