Open report from form with criteria

[wh00t]

Hi

I am trying to open a report based on information entered into a form.

maybe this can be done through the underlying query, but I get an error message saying it's either wrong syntax or too complex

2 fields on form
StartDate - set as date
NoDays - set as integer

the criteria I would like to open the report with is..

Between StartDate And EndDate

EndDate being StartDate + NoDays

and advice?

 

[Rich]

Add an unbound textbox, set its control source to =DateAdd("d",[NumbOfDays],[StartDate]) if you name the control EndDate you can now use it in the query criteria