How to customise displayed Dates?

[kdm3]

A frustrating and somewhat annoying problem.

I have a lot of dates to show, and am looking down at alot of numbers - not particularly attractive, or easy to read. I what to make these dates more readable, and display it as for example

Fri, 3rd Sept, 2004

What is the best way to accomplish this - will I have to write a custom function using DATEPART, or is there a more succinct way of achieving this?

 

[ColinEssex]

Format the dates in the table

Col

 

[kdm3]

Setting default date order

An add-on problem - I just noticed that some of the dates appear to be in US format, "month-day-year", but I'm British and I use "day-month-year", how does one go about changing the default date order from US to UK format, cause this could really pose problems if I don't sort it...

A solution would be appreciated.

 

[The_Doc_Man]

Format$ is STILL the answer. The specific help topic is User-Defined Date Formats (or something close to that).

 

[Rich]

Change the Windows regional settings to the correct area

 

[The_Doc_Man]

Rich's answer is also correct but with broader scope of effect. If you only want this in Access, use my method. If you want it for everything on your computer, use his method.