Hi, all

I have abandoned the previous post.Now ->

How do you put a calculated value eg. sum of all entries in the footer of a data entry form in Access DataProject?

Regards

Error message, that Domain aggregate functions not allowed in VBA?

Thanks collegues,

Here is QryOrderfooter : purpose to compute the value of the items on the order form.

Alter Procedure QryOrderFooter

(

@OrderId int OUTPUT

)

As

SELECT OrderId,QTY,QtyValue, (QTY...

Correct, Moved to ACCESS ADP and my forms have gone beserk!

FE is in Access 2K (Office 2K SP3)

Hi, thanks, but this is from a VBA code behind a form where the computation is done:

Me.TotValue = DSum("Revenue", "QryOrderFooter")and qryOrderFooter is a stored procedure.

Hi, thanks, but this is from a VBA code behind a form where the computation is done:

Me.TotValue = DSum("Revenue", "QryOrderFooter")and qryOrderFooter is a stored procedure.