UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Update Query    
 
   
spin
post Feb 6 2005, 03:53 PM
Post #1

New Member
Posts: 6
I have recently created an update query:

UPDATE Fixtures SET Total = ([Players Attitude]+[Clubs Official Attitude]+[Club Supporters Attitude]);

I basically want to know now, is there a way of getting this to automatically run when new data is added into the Fixtures table(Table that is being updated), because currently you have to run the query for it to work

Thanks
Go to the top of the page
 
+
DougY
post Feb 6 2005, 03:58 PM
Post #2

Utterly Abby-Normal
Posts: 9,756
From: Seattle, WA [USA]
Hi,

Why do you want to store a calculate field?? You should get value on the fly using query/form/report.
Go to the top of the page
 
+
R. Hicks
post Feb 6 2005, 04:00 PM
Post #3

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
You should not store this calculated value in your table ...

RDH
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 12:09 PM