error in result dcount query

[mohamedmatter]

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

 

[theDBguy]

Hi. For the first query, you could try something like:

SELECT Count(*) FROM Course_tbl WHERE Course_Name="sql" AND Course_Date=#1/31/2020#

And for the second one, you could try:

SELECT Count(*) FROM Course_tbl WHERE Course_Name In("sql","word") AND Course_Date=#1/31/2020#

Hope that helps...

 

[mohamedmatter]

thankes it works
how learn instructions to write sql in query

 

[theDBguy]

thankes it works
how learn instructions to write sql in query

Hi. You're welcome. You could start learning the basics from here.

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

 

[mohamedmatter]

Hi. You're welcome. You could start learning the basics from here.

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

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

 

[Dreamweaver]

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

 

[mohamedmatter]

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
View attachment 79293

thanks but i want to count course_name without duplicate

 

[Dreamweaver]

Just change the field in query3 for what you need