date format manipulation in database results

[Tim Thorp]

Hi,

I have a training database with events stored in an access table. The field
is a date/time field. I need my database results to output in yyyymmdd
format. How do I control the date output?

Thanks,

Tim