Problems with table (1 Viewer)

[vVHenryVv]

Hi guys, I'm new to microsoft access and I need some help with regard to the access 'table' for my school project. Our lecturer has given us a scenario with the table "Salesperson". She asked for the data type to be set as "Number", and the field name "Commission rate".

I had the format as "percent" in my attempt to set the commission rate as 10%. However,the attempt proved futile. Any number less than 100 would automatically appear as 0% in my "Commission rate" column.

How should I go about solving this?

 

[JANR]

Hint: Change Fieldsize from Long Integer to..... a more propriate format, like single or double

JR

 

[vVHenryVv]

Thanks, it's working now!

 

[janbaz2009]

hi friends ! i need help for the field "Date" input mask . i want to input only month and year. "mm-yyyy". any one guide me . i thankfull him .