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?