June 15, 2009 at 9:46 am
I am very new to access....
I have a table with a Material in M1, the quantity of that Material in M1Q, and M1C which will remain empty for now.
I need to run a script that goes:
If data in M1 is Glue Then multiply M1Q by 10.5 and put the result in M1C.
Any help would be appreciated.
June 15, 2009 at 4:41 pm
Try this,
Update [YourTableNameHere] Set M1C = M1Q * 10 where M1 = 'Glue'
"When in danger or in doubt. Run in circles, scream and shout!" TANSTAAFL
"Robert A. Heinlein"
June 17, 2009 at 11:38 am
That's great however where do I actually put this line?
Would it be on the Form, or the Query, or the Table?
June 17, 2009 at 12:34 pm
Which version of Access are you running?
If you are running the script one time or on occasions you would create a query to perform the operation.
"When in danger or in doubt. Run in circles, scream and shout!" TANSTAAFL
"Robert A. Heinlein"
June 17, 2009 at 1:17 pm
2003
June 17, 2009 at 1:32 pm
Try this link: http://www.teacherclick.com/access2003/t_10_2.htm
How to create an Update Query in Access 2003
"When in danger or in doubt. Run in circles, scream and shout!" TANSTAAFL
"Robert A. Heinlein"
June 17, 2009 at 1:34 pm
thank you
June 17, 2009 at 1:45 pm
Not a problem.
Here is a great list to subscribe to for "Access".
After you get a login you have access to years of questions and answers to common and unique problems.
I have used it since 1997.
http://peach.ease.lsoft.com/scripts/wa.exe?A0=ACCESS-L
"When in danger or in doubt. Run in circles, scream and shout!" TANSTAAFL
"Robert A. Heinlein"
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply