I having a table which has "previousDate", "nextDate" fields in it (Date/Time - Access 2003). In CR9 I created a datetype parameter (SelDt). Now I want to set the parameter to connect to both the above two fields datefields. I opened the select expert and selected the previousDate. Then I opened the formula Editor found in the select expert dialog and added
or {Table1.nextDate} ={?selDt}
assuming it would check for both the fileds and populate the records accordingly. The final code/formula looks like this
{Table1.previousDate} ={?selDt} or {Table1.nextDate} ={?selDt}
when I ran the report I saw all the records being displayed instead of the ones being selected by the user from the prompt dialog. Individually if only one field is used in the parameter it works fine, but when combined it throws out all data.
Note: I donot want to use two parameters.
Any ideas where I am going wrong.