Querying column function

[Guest]

I have three columns of data: Component name, ComponentPrice, ComponentLabor.
I have created a form for data entry so the user can enter in the quantity
(via textbox) on form. From this point I am trying to calculate the total
price as well as the total labor. On the form I have several combo boxes,
that I am utilizing to show grouped component names that are related to each
other.
As of now I do not have a bound control for the total price textbox nor the
total labor textbox. Which I think is a mistake! Because now I can not
retrieve the information that I need only if I have the form open.
How can I do this in a query? In the query design view, Access does not
allow me to use the column property for my fields that are combo boxes?

 

[Michel Walsh]

Hi,

Have you tried a total (Group by) query? In the query designer, click on the
toolbar button with the Summation symbol (a capital Sigma, a M rotated by 90
degree) and a new line, Total, will appear in the grid. There, you can
define GROUP, as example, Group By on ComponentName, and aggregate, like SUM
on ComponentPrice, to get things like the sum(componentPrice) for each
ComponentName.



Hoping it may help,
Vanderghast, Access MVP