error in result dcount query (1 Viewer)

mohamedmatter

Registered User.
Local time
Today, 16:51
Joined
Oct 25, 2015
Messages
112
I attach courses Db

I want to dcount sql course and date > #31/1/2020# in Sql query

I want to dcount [sql and word] course and date > #31/1/2020# in sql_word query

I tired but error display when run queries

And

I want instructions to write function in query

Many thanks
 

Attachments

  • Courses.zip
    23.5 KB · Views: 95

theDBguy

I’m here to help
Staff member
Local time
Today, 16:51
Joined
Oct 29, 2018
Messages
21,358
Hi. For the first query, you could try something like:
SQL:
SELECT Count(*) FROM Course_tbl WHERE Course_Name="sql" AND Course_Date=#1/31/2020#

And for the second one, you could try:
SQL:
SELECT Count(*) FROM Course_tbl WHERE Course_Name In("sql","word") AND Course_Date=#1/31/2020#
Hope that helps...
 

mohamedmatter

Registered User.
Local time
Today, 16:51
Joined
Oct 25, 2015
Messages
112
thankes it works
how learn instructions to write sql in query
 

theDBguy

I’m here to help
Staff member
Local time
Today, 16:51
Joined
Oct 29, 2018
Messages
21,358
thankes it works
how learn instructions to write sql in query
Hi. You're welcome. You could start learning the basics from here.

 

mohamedmatter

Registered User.
Local time
Today, 16:51
Joined
Oct 25, 2015
Messages
112
Hi. You're welcome. You could start learning the basics from here.

when i try example in site send to me this error display
i want to count distinct course_name in query 2
 

Attachments

  • bandicam 2020-02-22 09-28-52-409.jpg
    bandicam 2020-02-22 09-28-52-409.jpg
    266.3 KB · Views: 95
  • Courses.zip
    29.5 KB · Views: 104

Dreamweaver

Well-known member
Local time
Today, 23:51
Joined
Nov 28, 2005
Messages
2,466
I've added Query3 which shows distinct course count for a date
Open the query and view the property sheet by right clicking in the area where the tables are.

hope it helps
mick
2020-02-22.png
 

Attachments

  • Courses.zip
    36.4 KB · Views: 95

Users who are viewing this thread

Top Bottom