Data Manipulation 101 – Formatting a date field for output. More information than you’ll ever need on this site: http://www.techonthenet.com/access/functions/date/format.php
Example
Convert a date field from mm/dd/yyyy to remove the slashes:
Format([date], “mmddyyyy”) will get you 01201975 If the date was “1/20/1975”