A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HELP: Update 1 table with calculated fields from another table



 
 
Thread Tools Display Modes
  #1  
Old May 23rd, 2004, 05:16 PM
Samora
external usenet poster
 
Posts: n/a
Default HELP: Update 1 table with calculated fields from another table

Hello

I have a form who have 10 fields from TABLE1 that after make calculations with them
i build the field M1 from TABLE2

The event that fires those calculations is AFTER UPDATE field D1 from Table TPavimentos in Form FrmCalculo

How can i update the TABLE2 - field M1 ??

the tables a
TPavimentos
TMomentos

Form FrmCalculo

Table to be updated TMomentos
Field to be update M1

the field M1 has to be calculated a several times:
on position 0 and position 250
For position = 76 to 174


for both situations the formula is the same.

the table is an intermediate table from where i have to get some values for the next calculations and i DONT HAVE
ANY FIELD that can make a relation between TPavimentos and TMomentos

Important: I dont want to store these values in table TPavimentos but only in table TMomentos

PLEASE : DON'T LOOK TO MY POST NAMED "FROM ONE TABLE UPDATE THE FIELDS FROM OTHER TABLE" .

IT'S THE SAME THING, BUT THE EXPLANATION OF THE PROBLEM WAS UNCOMPLETE.

THANK YOU

Best regards
Samora



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.