var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Using Select and updating the table
With all of the help here my database is almost to the point where it works!
I just have one problem.
If I use the following in a query:
Switch(asscomp_code IS NOT NULL,'NONRISK') AS risk_nonrisk_type
When I input changes, it changes the risk_nonrisk_type field to NONRISK in the query, but it won't update it in the table Details. Is there a way so that it will also update the table automatically?
Run an UPDATE Query (not SELECT) with the following Syntax to update a particular record:
Don't forget to add the WHERE clause to refer to specific record or group of records.
UPDATE Details SET Details.risk_nonrisk_type = Switch(asscomp_code IS NOT NULL,'NONRISK')
NB: Backup a copy of your table before attempting to try out the above example.
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007
Originally Posted by apr pillai
Thanks! Able to use this. If I need more help I'll come back here!