How do use a sum function to call a control in subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to input my song times into my subform and have them automatically
calculated in a main form control. i.e. type 3:50 in one song and 3:50 in
another song and have them both add up to 7:00 on the main form.
Is there anyone who could help me with this?
-AccessComp
 
You can use the DSum aggregate function on the underlying table.

Having said that, be aware that date fields aren't really intended to hold
durations: they're intended for timestamps (specific points in time). Note,
too, that if the total is more than 24 hours, you'll lose the day part.
(i.e.: rather than 25:10, you'll get 1:10) Also, 3:50 + 3:50 is 7:40, not
7:00.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to always get the top level form reference, when calling from any subform/subform... 0
Retrieve a value from an unbound control on a subform 4
Access Reference Subform's Control 0
Running Total from a Subform 1
Using an append query in a subform 1
Access Daily Entry with multiple entries per field 0
Focus to SubForm Control 10
Main Form / Subform Totals 3

Back
Top