how to format discount in tbl

[byenvag11]

i import my excell table to access for some reason it doesnt show the percent symbole. how do i display discount in my tbl in the desing view

 

[ajetrumpet]

use the decimal type under NUMBER. in the DISPLAY AS, choose "%".

 

[boblarson]

You really should format at the form/report level and not at the table level. Nobody should be working in the tables directly anyway so it shouldn't matter. If they are working in the table directly then I would suggest you stop that right away as you lose major control over things when that occurs.