Extending cost FORMULA in sub form

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
 
W

Wayne Morgan

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

Guest

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

Wayne Morgan

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

Lou

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill fields in sub form 1
Units of Measurement 1
Need to multiply Quantity by Cost and Retail Cost 1
Updating Fields in One Table Based on a Field in Another Table 1
Sub Form Formula 8
Linking Tables with Main Form 3
Sum field in query won't show on form 3
% sum calculation from sub form 1

Top