Search results

thank you i want cerate in column in query used dcount - because i want to insert other devices in this querylook this imag

I attach simple database name school I want query to count 1- All namedevice = computer by devicekind = p4 in lab A to school 2- All namedevice=datashow in school in all labs in school

error in bmp

query name total of devices in school table1 filed id, schoolname table2 filed id-lab ,lab name,device-name;device-kind i want query count device in lab in school by dcount error =dcount("[id-lab]";"[table2]";"[device-name]='tv' and [device-kind]='samsung' and [id-lab]="& [id]) when run query...