I need help !!! (1 Viewer)

[atommy]

hello and sory for my english...
i have aproblem with a reripe cost access template that i found in internet
the problem is in the reripe form i can not fix the [Total] field of the resipe form that is taking the sum of the other field subform ??
i realy dont now many thinks about Access but i realy need this solution if is possible . Thanks

 

[bob fitz]

I have tried to examine the db you posted but although it has an mdb file extention, I am unable to run it.
If I have understood your requirement correctly, you could try the following expression as the Control Source property of the text box in the footer section of the sub form:-
=Sum(([IngredientQTY]/[Purchase Quantity])*[Purchase Cost])
EDIT:
Crossposted: http://www.accessforums.net/access/i-need-help-43751.html

Please read: http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

 

[atommy]

yes this is the problem but i have all ready test it and faild ?

 

[bob fitz]

yes this is the problem but i have all ready test it and faild ?

Can you be more specific. What result did you get using

=Sum(([IngredientQTY]/[Purchase Quantity])*[Purchase Cost])

 

[atommy]

# error my subform is this:suform.jpg
and sorry i can't (i try) make my Access to accdb
realy i dont want to make you waist your time if you now some other Access for resipe that is working plz let my now i just need it for my work. this one i fount it ok but is not working the subform .
Thanks again.

 

[atommy]

ok i make it .accdb

 

[bob fitz]

But I need it to be in A2003 mdb format

 

[atommy]

Ok a2002-2003

 

[bob fitz]

atommy,

Take a look at the attached db. Does this give the desired results.

 

[atommy]

THANKS A LOT thanks thanks...........