dcount in query device (1 Viewer)

M

mohamedmatter

Registered User.

Local time

Today, 05:38

Joined

Oct 25, 2015

Messages

112

• Sep 25, 2018

• #1

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: 40

J

JHB

Have been here a while

Local time

Today, 14:38

Joined

Jun 17, 2012

Messages

7,732

• Sep 25, 2018

• #2

Database attached, open the two queries

 

Attachments

• school.accdb

  440 KB · Views: 37

M

mohamedmatter

Registered User.

Local time

Today, 05:38

Joined

Oct 25, 2015

Messages

112

• Sep 25, 2018

• #3

JHB said:

Database attached, open the two queries

Click to expand...

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

  89.8 KB · Views: 37

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 20:38

Joined

May 7, 2009

Messages

19,230

• Sep 25, 2018

• #4

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

 

Attachments

• school.zip

  26.4 KB · Views: 38

C

CJ_London

Super Moderator

Staff member

Local time

Today, 13:38

Joined

Feb 19, 2013

Messages

16,604

• Sep 25, 2018

• #5

follow on from this thread

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

OP seems to have abandoned it

 

M

mohamedmatter

Registered User.

Local time

Today, 05:38

Joined

Oct 25, 2015

Messages

112

• Sep 26, 2018

• #6

many thanks for you my best