Make a Table from a Qry + 3Fields

  • Thread starter Thread starter Mercy
  • Start date Start date
M

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
 
Where is this information stored? This is kinda like asking us to drive you
to work but not telling us where you work.
 
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


Mercy said:
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
Click to expand...


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

--
Duane Hookom
MS Access MVP


Mercy said:
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


Mercy said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top