data type

[lenni]

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

 

[Allen Browne]

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.

 

[Jerry Whittle]

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.