Populate Text Box w/Query

[bballhermit]

I have a project staffing form that displays employee records and their hours for each month of the selected year on the selected project (filtered by combo boxes) in a listbox. Also on the form, I want to have a couple text boxes that display the total number of hours and the total cost for the current project in the current year.

How can I create those query calculations and force the textboxes to be dynamically populated by the results? Is this something I want to use a DLookUp for? I am an Access Newbie.

Calculation Descriptions:
Budget Hours :: Sum of all hours worked by any employee in any month on the currently selected project.
Budget Cost :: Sum of All Employees of ( Employee Rate * Sum of Employee's Hours on Current Project)

See attached screenshot to see what I am working on.

Thanks!

 

[John Big Booty]

The DSum() function should do what you are after.

 

[bballhermit]

Ok, thanks.

The issue I'm having is that my sums need to account for multiple fields of data horizontally within one record, as well as fields all the way down. Can I do some sort of horizontal summation within the dsum command?

 

[John Big Booty]

Ok, thanks.

The issue I'm having is that my sums need to account for multiple fields of data horizontally within one record, as well as fields all the way down. Can I do some sort of horizontal summation within the dsum command?

That sound's suspiciously like a non-normalised tabled structure. I would recommend that your read up on and become familiar with the subject. This tutorial may help you in that process.

 

[bballhermit]

Ok. Thanks.