Good day! I have some code here that I would like to get some help identifing an IF statement.
=IIf([txt_Country]<>"CA",[rpt_txt_Tot_ROEC]*0.25,IIf([txt_RRSP]<>0,0,IIf([cmb_Province]="QC",IIf([rpt_txt_Tot_ROEC]>5000,[rpt_txt_Tot_ROEC]*0.1,[rpt_txt_Tot_ROEC]*0.05),[rpt_txt_Tot_ROEC]*0.1)))...
Amiel:
Thanks for the info. I should of explained that I am a REAL NEW user with ACCESS 2000. What you have said sounds great but to code it I really have no idea. I hope you can hrlp moi.
Thanks
Cricker
PHV:
Do you mean bound for the Control Source? If so yes. When the form loads up it it has the default selection = 1. When i go and try to select change selection it will not let me select any of them.
Cricker
PHV:
I am kinda new at this so I really haven't tried much. I did a bit of searching and what I found was to use the search/find feature in the MS ACcess itself and that is not what I want. I will look at the DLookUp function.
Cricker
Good day! I need a form to start up first so that the user can search a field to see if it there so they can either show the information on the MAIN FORM or show a blank form so that the user can enter in the information.
Cricker
Good day!! I have an option box that I designed through the wizard. The selection has to be either - English (1) or French (2). When the selection is made the value is not being saved to the table when its viewed.
I hope someone can help.
Thanks
Cricker
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.