Can I Do This in Report? ( A2k (9.0.4402) SR-1)

Topic

New Reply

Can I Do This in Report?

A2k (9.0.4402) SR-1

I have a report that prints the operator entered date range in the report page header

The Text Box: DateHeader control source is as follows:

=[Forms]![frmCriteriaHP]![txtDateType].[Caption] & ” ” & [Forms]![frmCriteriaHP]![txtStartDate].[Caption] & ” Thru ” & [Forms]![frmCriteriaHP]![txtEndDate].[Caption]

This works fine when operator enters Start and End Dates,

Date Range: 01/01/2002 Thru 01/31/2002

However if date range is not entered (which is OK) Thru prints by itself.

Date Range: Thru

Is there a way to wrap an If statement around the control source to test txtStartDate and txtEndDate for no date range and print None instead of Thru?

Date Range: None

Command syntax would be helpful.

Thanks, John Graves

Reply | Quote

Replies

Sure, just put an IIF statement in there.

For example,
=[Forms]![frmCriteriaHP]![txtDateType].[Caption] & ” ” & [Forms]![frmCriteriaHP]![txtStartDate].[Caption] & IIF(txtStartDate=””,””,” Thru “) & [Forms]![frmCriteriaHP]![txtEndDate].[Caption]

Reply | Quote

This can be done more elegantly by including the “thru” in a package with the end date:

=[Forms]![frmCriteriaHP]![txtDateType].[Caption] & ” ” & [Forms]![frmCriteriaHP]![txtStartDate].[Caption] & (” Thru ” + [Forms]![frmCriteriaHP]![txtEndDate].[Caption])

Now the “thru” won’t print unless the end date is entered.

Reply | Quote