35 pts.
 ACCESS 2010 query in CRYSTAL XI
In Access 2010, suppose query having a validation rule [90 bal %] = '0', when calling this query in CRYSTAL REPORT that '0' considered as a parameter and waiting for user to input value for [0]. Though '0' is a validation rule and also working fine when running in ACCESS 2010 whereas in CRYSTAL REPORT XI it is not. NOTE: [90 bal %] field defined as type TEXT in ACCESS 2010 TABLE. Any thoughts and help greatly appreciated.

Software/Hardware used:
WINDOWS 7
ASKED: July 6, 2012  2:34 PM
UPDATED: July 6, 2012  2:47 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. SQLlions   35 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _