hey guys!
i have yet another problem hehehe,
i have a report which runs off a query (Parameter Query).
before the report is opened, the query asks the user to enter the MemberID OR PostalCode.
what i want is the query to show all records if non of the above crieteria is entered upon running the query. how would i go about doing this!
oh 1 more thing, if i enter a MemberID or PostalCode, but no records are found, then instead of the report showing up BLANK, i want there to be an error message of some kind!
Thanx alot people!
SaTTy
i have yet another problem hehehe,
i have a report which runs off a query (Parameter Query).
before the report is opened, the query asks the user to enter the MemberID OR PostalCode.
what i want is the query to show all records if non of the above crieteria is entered upon running the query. how would i go about doing this!
oh 1 more thing, if i enter a MemberID or PostalCode, but no records are found, then instead of the report showing up BLANK, i want there to be an error message of some kind!
Thanx alot people!
SaTTy