Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Input FY Year In Form & Printing Cursor Report
Message
From
25/01/2001 08:53:51
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00468189
Message ID:
00468393
Views:
15
Freddie,

My guess is that your WHERE clause may be the problem. What's the format of SSP? If it's C(4) and contains for digit years, then you should use VAL(RIGHT(SSP,2))

>WHERE Val(left(SSP,2)) = nInputYear <
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform