Convert FoxPro 2.6 Code to MsAccess 2003
- From: "RNUSZ@OKDPS" <RNUSZOKDPS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 13:00:03 -0700
Old FoxPro 2.6 Form Letter Code follows:
It is further ordered, pursuant to 47 o.s. 7-206, that the license and
registration(s) of (licensee (lic_f_name, lic_m_ini, lic_l_name, lic_subt)),
(if lic_dl_sta="n") shall remain suspended unless (if security > " " ) said
security in the amount of (security) is posted and (eif) proof of current
insurance in your name is filed with this Department along with a $100.00
reinstatement fee in the form of a cashier's check or money order made
payable to the Department of Public Safety.(els) are hereby suspended unless
(if security > " " ) said security in the amount of (security) is posted and
(eif) proof of current insurance in your name is file with this Department
before (revocation date).
There are (4) possible outcomes of the above paragraph.
1). (conditional values of lic_dl_sta = n, and security not 1null) creates
It is further ordered, pursuant to 47 o.s. 7-206, that the license and
registrations of Robert Roberts shall remained suspended unless said security
in the amount of $300.00 is posted and proof of current insurance in your
name is filed with this Department along with a $100.00 reinstatement fee in
the form of a cashier's check or money order made payable to the Department
of Public Safety.
or
2. (conditional values of lic_dl_sta = n, and security is null) creates
It is further ordered, pursuant to 47 o.s. 7-206, that the license and
registrations of Robert Roberts shall remained suspended unless proof of
current insurance in your name is filed with this Department along with a
$100.00 reinstatement fee in the form of a cashier's check or money order
made payable to the Department of Public Safety.
or
3. (conditional values of lic_dl_sta = s, and security not null) creates
It is further ordered, pursuant to 47 o.s. 7-206, that the license and
registrations of Robert Roberts are hereby suspended unless said security in
the amount of $300.00 is posted and proof of current insurance in your name
is filed with this Department before 1 June 2005.
or
4. (conditional values of lic_dl_sta = s, and security is null) creates
It is further ordered, pursuant to 47 o.s. 7-206, that the license and
registrations of Robert Roberts are hereby suspended unless proof of current
insurance in your name is filed with this Department before 1 June 2005.
I need to be able to use this logic in an unbound text box on a report. Any
suggestions, everything that I have tried results with errors like
The expression you entered is missing a closing parenthesis ), bracket }, or
vertical bar. or similar error.
Thanks in advance....
--
Robert Nusz
Sr. Programmer Analyst II
.
- Follow-Ups:
- Re: Convert FoxPro 2.6 Code to MsAccess 2003
- From: Larry Linson
- Re: Convert FoxPro 2.6 Code to MsAccess 2003
- Prev by Date: How do I round a sum up to the next number, i.e. 2.25 to 3
- Next by Date: Re: Convert FoxPro 2.6 Code to MsAccess 2003
- Previous by thread: How do I round a sum up to the next number, i.e. 2.25 to 3
- Next by thread: Re: Convert FoxPro 2.6 Code to MsAccess 2003
- Index(es):
Relevant Pages
|
