Here is the logic of what I want to do .. Have a button on a form that goes and accesses a Query (COST_QRY), have code that runs through the query looking a a feild (COST) in each record and add the number. If number is not equal to 0(zero) do one then if yes do another.
**************************** dim total as double = 0 read COS_QRY record(n)- feild COST total = total + COST next (n) if total = 0 then blah blah blah else yeah yeah yeah end if **************************** TIA steve ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/