dcount in query device

[mohamedmatter]

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

 

[JHB]

Database attached, open the two queries

 

[mohamedmatter]

Database attached, open the two queries

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

 

[arnelgp]

check which query do you prefer (Query1 or Query2 or None).

 

[CJ_London]

follow on from this thread

https://www.access-programmers.co.uk/forums/showthread.php?p=1592647#post1592647

OP seems to have abandoned it

 

[mohamedmatter]

many thanks for you my best