This should be simple.
I have 2 tables, OrderHeader & OrderDetail
I am trying to edit prices via a query involving OrderDetail with price=0.
When creating a query with OrderDetail alone, I can edited ok,
But when I link the table to OrderHeader for date specification it does not allow me to edit the prices. It is in read mode.
How can I edit the table with the query ?
Please advice
Thank...
azzi2000
Last Activity: Oct 27 '06, 03:11 PM
Joined: Oct 20 '06
Location:
-
I guess you were right. I need to do the following:
First - Update the table
Second - Insert into the table
However I haven't used sql lately in Access. Do I need a procedure inserted into the query...
table1: item, price
Table2: item2, price2
How would the query execute both command ?
Please advice with a sample.....
Thank you.
Dré... -
Append and replace field contents in table
I have an existing table, I am trying to update the table.
Update existing records with new value and append to it non existing value.
Table 1: item, price
table 2: item, new price
Is there a query to do this. I tried Append and replace but I need to combine both.
Please help
THank you
dré -
I would just use the following:
Assuming sVar = "1061025" use the follwing
mid(sVar,4,2) & "/" & left(sVar,2) & "/" & mid(sVar,2,2)
=
10/25/06
however this would be a string,
but in sql must convert it to date, therefore use cdate(sVar)...Leave a comment:
-
This is exactly what I waas looking For.
THANK YOU. THANK YOU.
André...Leave a comment:
-
Export Query result To A Table
This should be rather simple.
I have a query using different link tables and 2 parameters.
The query works perfect.
However I need to export or save the result in an Access table in order to export it to an ascii file delimited. (Quote delimited with comma)
- I tried to export to an ascii but I am getting: Too few parameters.
It would be best if I can export the result to an Access table then export...
No activity results to display
Leave a comment: