data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im not sure what this question are asking, "When desiging a table when would
you assign the data type of number to a particular field?"

Can anyone please help
 
Homework questions, eh?

Perhaps you could open the Northwind sample database that installs with
Access. Open some tables in design view, and see if you can see any of type
Number.
 
Doing homework? You wouldn't happen to be one of my students at SWIC would you!

Use a number when you plan on doing math on that field. For example, you
don't add, subtract, divide, or multiply a Social Security Number or ZipCode.
Therefore they should be text fields. However you may need to add up a Cost
field so that should be a number, or, more properly a Currency data type
which is also a number.
 
Back
Top