Custom Date Fields on Access Table

[bradsr0138]

I have tables that have various date fields with dates in most of the fields. The date fields that are empty are fine, but I want to be able to put something like "N/A" in a date field if a date doesn't apply. Is there a way I can accomplish this? Thanks for any help offered.

Brad

 

[JamesMcS]

Don't think so, you'd have problems with type conversion failures if you ever used a query based on that table.

A workaround would be to set the data types to text so you can put NA or whatever in them, then if you ever need to use the fields as dates, use CDate([Field_Name]) to convert back to a date. Messy but it should work.