Problems ACCESS?

Question

My friend and I tried to figure out the way to change decimal place to 0 in Design View but we still couldn't. Can anyone show us?
And We couldn't use the COUNT function to count any technicians that have "Technician Number"=23
Thanks for yr. help

Answer 1

Hi,
For ur first question--> go to design view of ur table--> select the desired field-->Its data type should be number and see in the panel below--> the very first item is field size--> there u select Integer. and save changes.
For second question-->
run a query--> Select name,count(technicianNumber) from UR_Table_Name where technicianNumber=23 group by name