I have a table with 2 fields (Cost) and (CostTxt).
I need to update (CostTxt) with the value of (Cost), where (Cost) is 123 and (CostTxt) becames 000000000000123 .
The size of field (CostTxt) is 15.
Luis Freitas
Last Activity: Aug 20 '08, 01:24 PM
Joined: Jun 21 '07
Location: South Africa
-
Fill field to the size of the field
-
"Cross Tab" Table to "Simple" Query
I have a table with the following Fields:
Article and 8 fields that are Dates. Under each date is a quantity.
I would like to run a query that would have only 3 columns:
Article, Date and Quantity
Thank you very much -
My initial idea was to create a "history" table with the fields would be RecID, FieldChanged, OldValue, NewValue.
We have a table with more then 2 million records and every week I have to download from our Head Office a table that has new records and changes to existing records.
The table has 21 fields and 19 of them can be changed by the update query.
Can you help me with the code for the update... -
Track changes to records updated using an update query
I know how to track changes when they are done using a form.
Can they also be tracked if I run an update query?
No activity results to display
Leave a comment: