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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter field requires data!

Status
Not open for further replies.

EdMason

Programmer
Jan 19, 2001
13
US
I have several parameter fields set for my report. It requires that data be entered in some of these fields (Numeric and Date fields). Sometimes I do not want to enter data in these fields and would like for them to be blank or zero filled.
Is there some way that I can declare that these fields not to require data?
TIA
 
I usually use ”parameter” fields to limit the report (ex: from and to date), if I leave the parameter blank it returns all dates. You may write a formula: “IF {parameter} = 0 Then 0 Else {parameter}

Good luck
Rune
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top