How to automatically populate a table with query results

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

How do I do the following? My database is:



Table Title - Main



Field in Main Table



[Pricingdata] - Numeric - contains Pricing data



Query - Contains [Pricingdata] from Main Table

Contains Expression Field: ([New Pricing Data]= [Pricingdata] +
..10)





Desired Result:



I want to automatically overwrite all data in the Main table [Pricingdata]
field with results of the query Expression Field.



Any assistance is deeply appreciated.
 
I want to automatically overwrite all data in the Main table [Pricingdata]
field with results of the query Expression Field.
Click to expand...

Change the query to an Update query, and update [pricingdata] to the
expression.

It's probably a good idea to back up your database first - update queries are
NOT reversible.

John W. Vinson [MVP]
 
John:

Thanks tons for comments. Tried your suggestion and all works perfectly.

Thanks once again for your timely post.
 
Back
Top