Thanks for the prompt reply. I am looking for help on an appropriate way to set up the data base to enter and sort the two different types of dates for photographs.e.g "c1990" or "26 March 2010". I assume Access does not allow two different date formats to be used in a single date field.

---

Reply from Alex Hedley:

You can only have one date, you'd need to put in day month and year.
You could have another field that determines what to show, day, month or year and then use that to format the date to only show the year.