Expression in Forms

[JC]

Hi

I have a main form with many sub forms. Have sub totalled on most of the sub
forms. I created a crosstab query to total all monies on each brand - then
want to subtract this total from the budget subform within my main form.

The crosstab includes the columns - shortname(code for brand), cost,
quantity with the expression to cost*quantity. The query does not group the
total under the shortname.

Any ideas?

Thanks

 

[John W. Vinson]

Hi

I have a main form with many sub forms. Have sub totalled on most of the sub
forms. I created a crosstab query to total all monies on each brand - then
want to subtract this total from the budget subform within my main form.

The crosstab includes the columns - shortname(code for brand), cost,
quantity with the expression to cost*quantity. The query does not group the
total under the shortname.

Any ideas?

Thanks

Please post the SQL view of the query, and indicate what it's returning and
what you want it to return. It's impossible to debug based on what you've
posted here.

 

[JC]

TRANSFORM Sum([inventory].[unitprice]*[quantity]) AS [Total Of UnitPrice]
SELECT Brands.ShortName
FROM (Brands LEFT JOIN Inventory ON Brands.ShortName = Inventory.SHortName)
LEFT JOIN Orders ON Inventory.Style = Orders.Style
GROUP BY Orders.Quantity, Inventory.UnitPrice, Brands.ShortName
PIVOT Brands.ShortName;

 

[John W. Vinson]

and indicate what it's returning and