Wednesday, 11 March 2009

Type your data right (please)

Look, just use the right data type for a field please!

Really, it's not that hard to do:
  • do you want to do some maths with it? Make it number or currency then
  • is it numbers you'll never want to add up? Make it text already
  • dates or times? Hmm, Date/Time then? But change the Format to make it appropriate OK? (like, I don't need the time if I'm just recording a date do I?)
  • is it only going to be answered Yes/No? Hmm, what about a Yes/No field type (it's called a Boolean variable if you want to get geeky)
  • and, please, if it's going to be an ID number than use the Autonumber type. It makes so much sense
There you go - easy peasy. Lemon. Squeezy.

So think about it, OK?

No comments: