[RESOLVED] Database design

[aikidokid]

Access 2002

I have a default value of "" for all Text and Memo fields.

What should I have for default values in the Date/Time fields, or should I just leave then empty and check for a null value?

Thanks

[GaryMazzone]

I would say that depends on what you are using the field for. If it is lasted editied or entered date the defalut to the current date. If it represents something else then it should default to NULL.

[aikidokid]

I would say that depends on what you are using the field for. If it is lasted editied or entered date the defalut to the current date. If it represents something else then it should default to NULL.

Thanks.

Perhaps I should have mentioned that this is being used as a backend and not a full access database program, it may make a difference.

I have 4 dates, two of which will (should) not be changed once entered:
DOB & Date joined.

The other two are dates that would be updated on an infrequent basis.
Last renewed membership payment
Last competition entered

It's just if there is no date, say for the last competition entered, I wouldn't want any date in, so I gues I would have to go with the checking for Null values.

Thanks again.

[Hack]

Is this resolved or do you have more questions on this issue?

[aikidokid]

Is this resolved or do you have more questions on this issue?

Sorry, forgot about this one.

It's resolved, as I have gone with checking for a Null value.

[Hack]

Thanks.