Why do I not see the results of an lIF expression in forms in my T MDS_frustrated 12/30/2008 8:17:24 PM Wrote an If expression in the form Access 2007. Function works in the form but the results do not appear in the associated Table from which the form was generated? The output of the IF is True = 1, and False = 0. These values work appear correctly in the Form but are absent in the Table. On generating a Split Form, the values appear both in the Form and Split Table of the Form, but again not in the original Table from which the Split generated from. Other info: Field type for the operation of the IF expression was Number (Integer); actual formula: IIF(DateX=Date();1;0). When DateX is the same as the current date, '1' is displayed in a field, otherwise '0' is shown. These two values appear as expected on the Form, but do not appear in the Table for each record generation.

Re: Why do I not see the results of an lIF expression in forms in my T "Gina Whipp" <NotInterested[ at ]InViruses.com> 12/30/2008 8:52:30 PM MDS, Not sure I understand the Split Table but results for an If expression written in a query do not automatically post to a table unless you are using an update query. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "MDS_frustrated" <MDS_frustrated[ at ]discussions.microsoft.com> wrote in message news:221F556C-6794-43CD-96C8-A4BA69156740[ at ]microsoft.com... [Quoted Text] > Wrote an If expression in the form Access 2007. Function works in the form > but the results do not appear in the associated Table from which the form > was > generated? The output of the IF is True = 1, and False = 0. These values > work appear correctly in the Form but are absent in the Table. On > generating > a Split Form, the values appear both in the Form and Split Table of the > Form, > but again not in the original Table from which the Split generated from. > Other info: Field type for the operation of the IF expression was Number > (Integer); actual formula: > IIF(DateX=Date();1;0). When DateX is the same as the current date, '1' is > displayed in a field, otherwise '0' is shown. These two values appear as > expected on the Form, but do not appear in the Table for each record > generation.

Re: Why do I not see the results of an lIF expression in forms in my T fredg <fgutkind[ at ]example.invalid> 12/30/2008 9:09:25 PM On Tue, 30 Dec 2008 12:17:24 -0800, MDS_frustrated wrote: [Quoted Text] > Wrote an If expression in the form Access 2007. Function works in the form > but the results do not appear in the associated Table from which the form was > generated? The output of the IF is True = 1, and False = 0. These values > work appear correctly in the Form but are absent in the Table. On generating > a Split Form, the values appear both in the Form and Split Table of the Form, > but again not in the original Table from which the Split generated from. > Other info: Field type for the operation of the IF expression was Number > (Integer); actual formula: > IIF(DateX=Date();1;0). When DateX is the same as the current date, '1' is > displayed in a field, otherwise '0' is shown. These two values appear as > expected on the Form, but do not appear in the Table for each record > generation. Access is working correctly. A calculated result is NOT stored in a table. Why would you want it to? That resulting value might be correct today, but it will certainly be incorrect tomorrow. Besides, using your expression, into which field should Access store the value even if it could? Instead of trying to store that value, anytime you need the result of that calculation, re-calculate it, either on the form or report, or in a query. By the way, your expression could cause confusion further down the road. In Access, -1 is True (not 1), so someone reading your code in the future may very well be confused when trying to further use the calculated results. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail

Re: Why do I not see the results of an lIF expression in forms in my T "BruceM" <bamoob[ at ]yawhodotcalm.not> 12/31/2008 1:35:10 PM "Split table" may be a reference to a split form as described here under "What's good": http://allenbrowne.com/Access2007.html Allen describes the split form thus: "A synchronized Datasheet (for locating the record) and Form view (for editing.)" "Gina Whipp" <NotInterested[ at ]InViruses.com> wrote in message news:%23nJeJCsaJHA.796[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > MDS, > > Not sure I understand the Split Table but results for an If expression > written in a query do not automatically post to a table unless you are > using an update query. > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > "MDS_frustrated" <MDS_frustrated[ at ]discussions.microsoft.com> wrote in > message news:221F556C-6794-43CD-96C8-A4BA69156740[ at ]microsoft.com... >> Wrote an If expression in the form Access 2007. Function works in the >> form >> but the results do not appear in the associated Table from which the form >> was >> generated? The output of the IF is True = 1, and False = 0. These >> values >> work appear correctly in the Form but are absent in the Table. On >> generating >> a Split Form, the values appear both in the Form and Split Table of the >> Form, >> but again not in the original Table from which the Split generated from. >> Other info: Field type for the operation of the IF expression was Number >> (Integer); actual formula: >> IIF(DateX=Date();1;0). When DateX is the same as the current date, '1' >> is >> displayed in a field, otherwise '0' is shown. These two values appear as >> expected on the Form, but do not appear in the Table for each record >> generation. > >

Re: Why do I not see the results of an lIF expression in forms in my T "Gina Whipp" <NotInterested[ at ]InViruses.com> 12/31/2008 2:23:39 PM Thanks... I'll read up on that! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "BruceM" <bamoob[ at ]yawhodotcalm.not> wrote in message news:O%23Bsby0aJHA.4480[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > "Split table" may be a reference to a split form as described here under > "What's good": > > http://allenbrowne.com/Access2007.html > > Allen describes the split form thus: > > "A synchronized Datasheet (for locating the record) and Form view (for > editing.)" > > > "Gina Whipp" <NotInterested[ at ]InViruses.com> wrote in message > news:%23nJeJCsaJHA.796[ at ]TK2MSFTNGP04.phx.gbl... >> MDS, >> >> Not sure I understand the Split Table but results for an If expression >> written in a query do not automatically post to a table unless you are >> using an update query. >> >> -- >> Gina Whipp >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors II >> >> "MDS_frustrated" <MDS_frustrated[ at ]discussions.microsoft.com> wrote in >> message news:221F556C-6794-43CD-96C8-A4BA69156740[ at ]microsoft.com... >>> Wrote an If expression in the form Access 2007. Function works in the >>> form >>> but the results do not appear in the associated Table from which the >>> form was >>> generated? The output of the IF is True = 1, and False = 0. These >>> values >>> work appear correctly in the Form but are absent in the Table. On >>> generating >>> a Split Form, the values appear both in the Form and Split Table of the >>> Form, >>> but again not in the original Table from which the Split generated from. >>> Other info: Field type for the operation of the IF expression was Number >>> (Integer); actual formula: >>> IIF(DateX=Date();1;0). When DateX is the same as the current date, '1' >>> is >>> displayed in a field, otherwise '0' is shown. These two values appear as >>> expected on the Form, but do not appear in the Table for each record >>> generation. >> >> >