Make a Table from a Qry + 3Fields

[Mercy]

Hi Everybody ^_^

I have a question.

I have a Form "OrderForm" which has a subform based on
the "Summary." "Summary" is:

SELECT [ManufacturerName], Details.Vendor, [OrderNum],
[Product], Details.ProductId, [Unit], Sum
(Details.Quantity) AS totalQuantity, [Cost]
FROM Details
GROUP BY [ManufacturerName], Details.Vendor, [OrderNum],
[Product], Details.ProductId, [Unit], [Cost];

The thing is ... I need to add 3 more pieces of
information to each record in the subform. These 3
pieces of info are: "ActualQtyOrdered", "ActualUnit",
and "TotalCost"

To put I simply I want a table that has all the info
of "Summary" plus 3 more fields. Is there any way to do
this?

Thanks for any input!
Mercy

 

[Duane Hookom]

Where is this information stored? This is kinda like asking us to drive you
to work but not telling us where you work.

 

[Mercy]

Hi Duane,

I like the analogy ^_^

The Information in the Subform "Summary" is from a Qry
which pulls it's information from a UNION Qry "Details".
Details pulls it's information from a tables Fabric &
Trim.
Here's a brief explanation of a few fields in "Summary"
Product --> Product to be Ordered
Unit --> Unit that totalQuantity is calculated in
totalQuantity --> The MINIMUM amount of the Product
Required
Cost --> The official Cost for an Official unit of this
product.

The fields that I want to add:

"ActualQtyOrdered": This is a new piece of information
that the USER is supposed to enter that

"ActualUnit": This is the "Official" Unit with which to
Order the Product. This is a value pulled from a Product
Table

"TotalCost": This is Calculated field that will multiply
Cost & ActualQtyOrdered for each record in Summary.


I hope that tells you where I work ^_^
-Mercy

-----Original Message-----
Where is this information stored? This is kinda like asking us to drive you
to work but not telling us where you work.

--
Duane Hookom
MS Access MVP

Hi Everybody ^_^

I have a question.

I have a Form "OrderForm" which has a subform based on
the "Summary." "Summary" is:

SELECT [ManufacturerName], Details.Vendor, [OrderNum],
[Product], Details.ProductId, [Unit], Sum
(Details.Quantity) AS totalQuantity, [Cost]
FROM Details
GROUP BY [ManufacturerName], Details.Vendor, [OrderNum],
[Product], Details.ProductId, [Unit], [Cost];

The thing is ... I need to add 3 more pieces of
information to each record in the subform. These 3
pieces of info are: "ActualQtyOrdered", "ActualUnit",
and "TotalCost"

To put I simply I want a table that has all the info
of "Summary" plus 3 more fields. Is there any way to do
this?

Thanks for any input!
Mercy

.

 

[Duane Hookom]

I would rethink this. You can't enter/edit data in a union query or a totals
query.

--
Duane Hookom
MS Access MVP

Hi Duane,

I like the analogy ^_^

The Information in the Subform "Summary" is from a Qry
which pulls it's information from a UNION Qry "Details".
Details pulls it's information from a tables Fabric &
Trim.
Here's a brief explanation of a few fields in "Summary"
Product --> Product to be Ordered
Unit --> Unit that totalQuantity is calculated in
totalQuantity --> The MINIMUM amount of the Product
Required
Cost --> The official Cost for an Official unit of this
product.

The fields that I want to add:

"ActualQtyOrdered": This is a new piece of information
that the USER is supposed to enter that

"ActualUnit": This is the "Official" Unit with which to
Order the Product. This is a value pulled from a Product
Table

"TotalCost": This is Calculated field that will multiply
Cost & ActualQtyOrdered for each record in Summary.


I hope that tells you where I work ^_^
-Mercy

-----Original Message-----
Where is this information stored? This is kinda like asking us to drive you
to work but not telling us where you work.

--
Duane Hookom
MS Access MVP

Hi Everybody ^_^

I have a question.

I have a Form "OrderForm" which has a subform based on
the "Summary." "Summary" is:

SELECT [ManufacturerName], Details.Vendor, [OrderNum],
[Product], Details.ProductId, [Unit], Sum
(Details.Quantity) AS totalQuantity, [Cost]
FROM Details
GROUP BY [ManufacturerName], Details.Vendor, [OrderNum],
[Product], Details.ProductId, [Unit], [Cost];

The thing is ... I need to add 3 more pieces of
information to each record in the subform. These 3
pieces of info are: "ActualQtyOrdered", "ActualUnit",
and "TotalCost"

To put I simply I want a table that has all the info
of "Summary" plus 3 more fields. Is there any way to do
this?

Thanks for any input!
Mercy

.