dcount in query device (1 Viewer)

mohamedmatter

Registered User.
Local time
Today, 08:06
Joined
Oct 25, 2015
Messages
112
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
 

Attachments

  • school.accdb
    512 KB · Views: 39

JHB

Have been here a while
Local time
Today, 16:06
Joined
Jun 17, 2012
Messages
7,732
Database attached, open the two queries
 

Attachments

  • school.accdb
    440 KB · Views: 36

mohamedmatter

Registered User.
Local time
Today, 08:06
Joined
Oct 25, 2015
Messages
112
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
 

Attachments

  • 3.jpg
    3.jpg
    89.8 KB · Views: 36

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:06
Joined
May 7, 2009
Messages
19,169
check which query do you prefer (Query1 or Query2 or None).
 

Attachments

  • school.zip
    26.4 KB · Views: 37

Users who are viewing this thread

Top Bottom