I need help !!!

A

atommy

New member

Local time

Today, 07:24

Joined

May 10, 2014

Messages

6

• May 10, 2014

• #1

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

 

Attachments

• Recipe Cost.zip

  84.7 KB · Views: 133

bob fitz

AWF VIP

Local time

Today, 15:24

Joined

May 23, 2011

Messages

4,807

• May 10, 2014

• #2

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

 

Last edited: May 10, 2014

A

atommy

New member

Local time

Today, 07:24

Joined

May 10, 2014

Messages

6

• May 11, 2014

• #3

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

 

bob fitz

AWF VIP

Local time

Today, 15:24

Joined

May 23, 2011

Messages

4,807

• May 11, 2014

• #4

atommy said:

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

Click to expand...

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

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

 

A

atommy

New member

Local time

Today, 07:24

Joined

May 10, 2014

Messages

6

• May 11, 2014

• #5

# 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.

 

Attachments

• 
  subform.jpg

  102.5 KB · Views: 117

Last edited: May 11, 2014

A

atommy

New member

Local time

Today, 07:24

Joined

May 10, 2014

Messages

6

• May 11, 2014

• #6

ok i make it .accdb

 

Attachments

• Recipe Cost.accdb

  636 KB · Views: 111

bob fitz

AWF VIP

Local time

Today, 15:24

Joined

May 23, 2011

Messages

4,807

• May 12, 2014

• #7

But I need it to be in A2003 mdb format

 

A

atommy

New member

Local time

Today, 07:24

Joined

May 10, 2014

Messages

6

• May 13, 2014

• #8

Ok a2002-2003

 

Attachments

• Recipe Cost A2003.mdb

  560 KB · Views: 107

bob fitz

AWF VIP

Local time

Today, 15:24

Joined

May 23, 2011

Messages

4,807

• May 14, 2014

• #9

atommy,

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

 

Attachments

• Recipe Cost A2003 (2)Bob.mdb

  580 KB · Views: 118

A

atommy

New member

Local time

Today, 07:24

Joined

May 10, 2014

Messages

6

• May 19, 2014

• #10

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