Extending cost FORMULA in sub form

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

Good Day Everyone;

I need a little help with my sub form, I have a recipe
database that I am adding a [cost] piece to. My table are
as follows,

tables-
tblRecipes
tblIngredients
tblRecipeIngredients

Form:
frmRecipe
sbfrmIngredients

My problem is that I am trying to add a [extended_cost] to
the sub form, the sub form is created as such, it has 4
control sources,

[Ingredient] - combo box extracting list from ingredients
table.
[cost]- extracted with ingredient from ingredients table.
[quantity] - manually entered in the form.
[extended_cost] - I need this to calculate, [quantity]*
[cost].

Unfortunatelly I cannot get this to work correctly and get
the extended cost in thier. A single line looks as such,

Ingredient: Quantity: Cost: Ext_Cost:
Peas 4 .02 0

Any help would be great, let me know if you need any other
information, the tables are linked and the database
normalized. When you enter the information into the form
and sub form it is stored in the respective tables.

Access 2002
Thank you.
Lou
 
Set the control source of the extended cost textbox to

=[Cost]*[Quantity]

It will display the value when the textbox containing quantity updates. This
will occur as you leave the quantity textbox.
 
Wayne thank you, I am getting some funky figures though,

Ingredient Quantity Cost Ext Cost
Flour 12 .05 $12.00
Chicken 4 .36 $36.00
Salt 4 .01 $64.00
Pepper 4 .02 $68.00
Carrots 8 .15 $48.00
Bubblegum 3 2.45 $96.00

Any ideas, this is funky.
TY
Lou
-----Original Message-----
Set the control source of the extended cost textbox to

=[Cost]*[Quantity]

It will display the value when the textbox containing quantity updates. This
will occur as you leave the quantity textbox.

--
Wayne Morgan
Microsoft Access MVP


Good Day Everyone;

I need a little help with my sub form, I have a recipe
database that I am adding a [cost] piece to. My table are
as follows,

tables-
tblRecipes
tblIngredients
tblRecipeIngredients

Form:
frmRecipe
sbfrmIngredients

My problem is that I am trying to add a [extended_cost] to
the sub form, the sub form is created as such, it has 4
control sources,

[Ingredient] - combo box extracting list from ingredients
table.
[cost]- extracted with ingredient from ingredients table.
[quantity] - manually entered in the form.
[extended_cost] - I need this to calculate, [quantity]*
[cost].

Unfortunatelly I cannot get this to work correctly and get
the extended cost in thier. A single line looks as such,

Ingredient: Quantity: Cost: Ext_Cost:
Peas 4 .02 0

Any help would be great, let me know if you need any other
information, the tables are linked and the database
normalized. When you enter the information into the form
and sub form it is stored in the respective tables.

Access 2002
Thank you.
Lou
Click to expand...


.
Click to expand...
 
What is the data type of the fields and what formatting, if any, have you
applied to them?

--
Wayne Morgan
Microsoft Access MVP


Wayne thank you, I am getting some funky figures though,

Ingredient Quantity Cost Ext Cost
Flour 12 .05 $12.00
Chicken 4 .36 $36.00
Salt 4 .01 $64.00
Pepper 4 .02 $68.00
Carrots 8 .15 $48.00
Bubblegum 3 2.45 $96.00

Any ideas, this is funky.
TY
Lou
-----Original Message-----
Set the control source of the extended cost textbox to

=[Cost]*[Quantity]

It will display the value when the textbox containing quantity updates. This
will occur as you leave the quantity textbox.

--
Wayne Morgan
Microsoft Access MVP


Good Day Everyone;

I need a little help with my sub form, I have a recipe
database that I am adding a [cost] piece to. My table are
as follows,

tables-
tblRecipes
tblIngredients
tblRecipeIngredients

Form:
frmRecipe
sbfrmIngredients

My problem is that I am trying to add a [extended_cost] to
the sub form, the sub form is created as such, it has 4
control sources,

[Ingredient] - combo box extracting list from ingredients
table.
[cost]- extracted with ingredient from ingredients table.
[quantity] - manually entered in the form.
[extended_cost] - I need this to calculate, [quantity]*
[cost].

Unfortunatelly I cannot get this to work correctly and get
the extended cost in thier. A single line looks as such,

Ingredient: Quantity: Cost: Ext_Cost:
Peas 4 .02 0

Any help would be great, let me know if you need any other
information, the tables are linked and the database
normalized. When you enter the information into the form
and sub form it is stored in the respective tables.

Access 2002
Thank you.
Lou
Click to expand...


.
Click to expand...
Click to expand...
 
My apologies wayne I did not see your response so I opened
up a following thread. The thread is "Sub Form Formula".

Your help is greatly appreciated.
Lou

-----Original Message-----
What is the data type of the fields and what formatting, if any, have you
applied to them?

--
Wayne Morgan
Microsoft Access MVP


Wayne thank you, I am getting some funky figures though,

Ingredient Quantity Cost Ext Cost
Flour 12 .05 $12.00
Chicken 4 .36 $36.00
Salt 4 .01 $64.00
Pepper 4 .02 $68.00
Carrots 8 .15 $48.00
Bubblegum 3 2.45 $96.00

Any ideas, this is funky.
TY
Lou
-----Original Message-----
Set the control source of the extended cost textbox to

=[Cost]*[Quantity]

It will display the value when the textbox containing quantity updates. This
will occur as you leave the quantity textbox.

--
Wayne Morgan
Microsoft Access MVP


Good Day Everyone;

I need a little help with my sub form, I have a recipe
database that I am adding a [cost] piece to. My table are
as follows,

tables-
tblRecipes
tblIngredients
tblRecipeIngredients

Form:
frmRecipe
sbfrmIngredients

My problem is that I am trying to add a
Click to expand...
[extended_cost]
to
the sub form, the sub form is created as such, it has 4
control sources,

[Ingredient] - combo box extracting list from ingredients
table.
[cost]- extracted with ingredient from ingredients table.
[quantity] - manually entered in the form.
[extended_cost] - I need this to calculate, [quantity]*
[cost].

Unfortunatelly I cannot get this to work correctly
Click to expand...
and
get
the extended cost in thier. A single line looks as such,

Ingredient: Quantity: Cost: Ext_Cost:
Peas 4 .02 0

Any help would be great, let me know if you need any other
information, the tables are linked and the database
normalized. When you enter the information into the form
and sub form it is stored in the respective tables.

Access 2002
Thank you.
Lou


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top