need Course admission Count date wise

Sir,

I have tried different ways using calculated field.
But output is coming as a blank 5 rows count.
5 rows is right for dates 1 September to 30 September result, but showing blank rows.

I think using sql script in button will work. I am not able to write sql script in botton to consulate data, to count course sold date wise.

Please help me sir.

Regards
Nitin ingale

Nitin ingale,

I'm not totally sure what "Total Sell" meant. Since the search dates were defined to the student as RegDate, I assumed that you wanted the total count of students for each course within the search dates. One of the problems you have is that id_CourseDB within the StudentDB is empty for every record. Therefore student records and course records are disconnected. I manually updated the id_CourseDB inside of studentDB for all students with a Regdate within September.(5 Records). I defined a query button on the right side of the form to do the selection. It summarizes (counts) all the students for each course.  I did not touch your search button in case I have totally misunderstood your issue. See if the attached is what you are looking for.

Well unfortunately I just found out that your project is too large to upload. Here is the SQL for the SQLQuery button I placed on the form:

Select a.CourseCode,a.CourseName,b.Field,Count(a.id),a.id From CourseDB a 
  Left Join Field b On b.id = a.id_Field 
  Left Join StudentDB c On c.id_CourseDB = a.id 
  Where Date(c.RegDate) >= Date({DateTimePicker1}) and Date(c.RegDate) <= Date({DateTimePicker2})
  Group By a.CourseCode 

You will need to update the id_CourseDB in StudentDB or this query will not work. Whatever form does the updating is not updating the id_CourseDB. That needs to be fixed.

See attached. I created the Query button and I changed your script to click on the Query button when clicking on the main search button. Your search button is untouched.  I had to remove the backup folder and your database in order to upload here. You will need to copy your database back into the app folder before running.