Saving data

  • Thread starter Thread starter Hubbymax
  • Start date Start date
H

Hubbymax

It looks like older messages tend to not be anwered once they get to
far burried. Any way...

I have a form with two sub forms. I want to save information from all
3 to a table. Main table has main Requester information and draws from
the Dept table. Subform1 has order info including dates, person
placing the order etc, and draws from the REQ table. Subform2 holds
the details of the order. I have it set up this way because the info
on the main form and on subform1 stays the same for each item entered
on subform2 as part of the requsition.
Each record for an item detail enterd on subform2 must be saved with
the info from the main form and subform1 as a new record.

I have been advised that this can be done by creating a query that
would collect all the data from the forms and creat a new record each
time I enter a new item on subform2. I am very bad at queries and do
not know where to start. I'm rather new at using them and this is the
last hurdle to finishing my project.
 
There is a replica of what you are trying to do in the Northwind sample
database that comes with Access. If you haven't installed it, do so. Then in
the help menu, you should find a link to open it. Look at the Orders form
and subforms.
 
There is a replica of what you are trying to do in the Northwind sample
database that comes with Access. If you haven't installed it, do so. Thenin
the help menu, you should find a link to open it. Look at the Orders form
and subforms.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com








- Show quoted text -
Click to expand...

Thank you for the suggestion. I have addapted the NorthWind Order form
and sub for along with their queries. I am having problems with one
query below

SELECT Products2.StockNu, Products2.ProductName, (([NUnitPrice]+
[OUnitPrice])/2) AS AvgUnitPrice, Req4.Quantity, ((([NUnitPrice]+
[OUnitPrice])/2)*[QuantityIssued]) AS ExtendedPrice, Sum((([NUnitPrice]
+[OUnitPrice])/2)*[QuantityIssued]) AS ReqCost, Req4.StoresReqNo
FROM Products2 LEFT JOIN Req4 ON Products2.StockNu = Req4.StockNu2
ORDER BY Req4.StoresReqNo;

When I try to run it or the form it controls I get the message - "You
have tried to execute a query that does not include the specified
expression 'StockNu' as part of an aggregate function". I can't figure
out what is causing this.
 
Back
Top