Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Returning values in a sub report 1

Status
Not open for further replies.

Kingsteveiv

Technical User
Oct 8, 2001
20
US
I have a calculated field in my query that a sub report pulls from. For some of the records, the caluclation returns a value of zero (0). I do not want to include these records that have a value of zero (0) in my subreport. Is there anyway to filter these out?

any help would truly be appriciated.

thanks x 1,000,000

 
How about specifying criteria "where fld1 <> 0"??

35+ years of 'progress' -- can't we all just go wire boards again?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top