Calculation on Form

[Guest]

Hello all,

I have a table call Session which including Username and LoginMinutes (the
total time which student spent on every logging)

Now I would like to create a Form which is viewing the total time of every
student which I choose from Combobox.

How can I solve this problem!

Thanks for your help !

 

[Jeff Boyce]

One way to do this would be to create a Totals query, grouped by the Student
(?StudentID) and showing the Username (you could GroupBy this too) and Sum
of the LoginMinutes. Then use that query as a source for your form, and use
your unbound combobox to select which student.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Thanks Jeff,

But I tried to do that way before posting, but my Combobox didnt let me
choose students even through it has the list of student already.

Also I am wondering, when we choose student from Combobox like that, the
Total Time field will be changed the value to suit which student as well?

I am looking forward to another solution from you.

Thanks !

 

[Jeff Boyce]

Sorry, but I don't have another one -- perhaps one of the other 'group
readers can provide another approach. What I described is how I would do
this... just to clarify:

* a main form, with an unbound combobox based on the student table (or a
query thereof)
* a bound control on the main form to hold the StudentID (after selection)
* an AfterUpdate event for the combobox that requeries the main form and
loads the selected student's info
* a subform, based on a different table, but with a StudentID field in it
* the Parent & Child properties of the subform control on the main form
both set to StudentID
* the subform's checkbox gets an AfterUpdate event to requery the subform
to only select those still outstanding.

Is this what you are doing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hello Jeff,

Thanks for your recommendation, I didnt understand throughly about
AfterUodate in Combobox. As a resukt, I didnt get the answer. Now everything
is going well. Thanks for your help again

 

[new.cnnb.net]

;gjolgjohjpejhpajhpsb