Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Merge four tables into 1 cursor
Message
 
To
28/12/2004 09:29:25
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972379
Message ID:
00972568
Views:
16
OOO Now I understood (at least I think that :o))))

Put a two variables in report
i.e
custno
&
grp_change

for grp_change: SUM, value to store 1 RESET AT PCode

for custno: SUM, value to store IIF(grp_change<1,1,0), Reset at enmd of report

I am not sure if the IIF(grp_change<1,1,0) or IIF(grp_change<2,1,0) but You can test it both ways

then use custno for counter of the group
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform