Access update query using expression

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related You will save yourself time, and eliminate the possibility of manual errors.

Note: Due to the permanent effects of working with an update action query, you should always make a backup copy of your tables, or your database before attempting this option. Now consider the following scenario example, that will illustrate the use of a Microsoft Access Update query:.

The information provided in this document is provided "as is" without warranty of any kind. The most popular Microsoft Access Number Cruncher. Celebrating our 35th Year of Software Excellence. Vienna, Virginia Privacy Policy Webmaster. Toggle navigation.

Products Microsoft Access Products. All Microsoft Access Products. Total Access Admin. Total Visual Agent. Total Access Analyzer. Total Visual CodeTools. Total Access Components. Total Access Detective. Total Access Memo.

Total Visual SourceBook. Total Access Speller. Total Access Startup. Total Access Statistics. Multi-Product Suites. Total Access Ultimate Suite. Total Access Developer Suite. Total Visual Developer Suite.

Is there anyway to use an if statemet to define the criteria for a query? Hi all, I'm writing a database basically as a favour to someone.

For each question I have created a hidden text box which calculates a score 5 for no, 10 for yes which I have done with a IIF expression in the Control Source of the text box.

These are then totalled to give an overall score. This score is then used to calculate a grade A or B and a percentage score using the same IIF method in the control source. What I want to do though, is use this grade and percentage and write it to the individual record as data in the table - to use in reports and such like.

Is there any way I can do this? I've tried a few bits of VBA but to no avail. Is there a way that this can be done? Or have I approached this in entirely the wrong way??!!?

Hi, Is there a way on Access that when a total is calculated using an expression on a form that it could update the table itself with that total? Thanks for any help! I need to add more but i'm getting an error from this much I have recently deployed an application at work [work pcs all running A2K2], built with A2K3 on home computer. I split the database housing the backend on our server, named server, and using frontends on users pcs.

I am running a VB script that takes information from another linked db on server so everything would be housed together and not on users pc this script runs a query converts to xml, opens FTP and uploads the query along with.

I can get it to work from home, no problem. I can get it to work from my pc at work. But when I try on other pcs it can not find the db error msg or opened by another user in exclusive mode, yes I explored this option I dont think this it.

The VB needs to open pull from the 2nd db. Both the backend and 2nd db I get this message. Can anyone tell me how I can change this, the msg box says its out of trusted network. So I copied and actually opened on local pc, I could open it. Move it back to server and no such luck. Thanks for any posts, I am having to get this working before I load for other branch offices.

I have googled and searched forum, seems everything is geared towards "sandbox". First off, I am not sure if this belongs in the queries forum but it seems most of the question is geared towards a table so I have posted it here. At the moment I have a query that contains several fields that use nested IIf statements to determine which set of rules to apply. I was wondering if it is possible to somehow set the IIf variables up in a table and then for just to lookup the table in the query.