I currently have afield value in a form derived from a query which i need to record into the specified table.
How do I do it?
I have tried using a macro and the action Setvalue without any luck.
I currently have afield value in a form derived from a query which i need to record into the specified table.
How do I do it?
I have tried using a macro and the action Setvalue without any luck.
We need to see more info.
What table? What field(actually a control on a form)?
The SQL of the query.
Few use macros, so you may get responses in vba or other.
I have a subform that extracts the value of a Price and Description fields from a table "Products" with the Part Number as primary key.
The subform has a table "Lines" as the data source. I am trying to record the value of Price in the "Lines" table.
The value of Price is liable to change in future which can not change once entered.
So, I am trying to get the value [Products]![Price] = [Lines]![Price]
Hi Raj
Can you upload a zipped copy of the database?
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
I have following SQL in a subform for creating an invoice:-
SELECT [Order Lines].LineID, [Order Lines].[Part Number], Stock.Description, [Order Lines].Qty, Stock.ListPrice, [Order Lines].[Qty]*
[ListPrice] AS [Line total], ([Qty]*
[ListPrice])*0.2 AS Vat, ([Qty]*
[ListPrice])*1.2 AS [Total Due], [Order Lines].CustID, [Order Lines].InvID
FROM [Invoice totals] INNER JOIN (Stock INNER JOIN [Order Lines] ON Stock.[PartNumber] = [Order Lines].[Part Number]) ON [Invoice totals].InvID = [Order Lines].InvID;
I am trying to record the value of the field Stock.ListPrice on the file [Order Lines]with a field labelled [Price].
[
Hi mike60smart,
I am still in the process of building up the database and its not yet ready for publishing. Sorry
Raj,
Difficult to understand your setup without a sample database.
Prices change all the time, and you may sell items in a clearance or other sale, or offer some sort of loyalty program. See this link for an approach to storing Price.
Good luck.
Last edited by orange; 10-16-2020 at 05:27 AM. Reason: spelling
I would advise you save yourself some grief and remove any and all spaces in object names (fields, tables, queries, forms and reports are objects)
So [Order Lines].LineID, [Order Lines].[Part Number] would become
[OrderLines].LineID, [OrderLines].[PartNumber]
or
[Order_Lines].LineID, [Order_Lines].[Part_Number]
Personally, I use camel case (OrderLines -> the first letter of each word is a capital letter)