required a new field from a table

[jsrkr55]

Hi,

I am working on a report which is displaying a set of records but now i should include a date range option which will filter the data but whenever i am trying to add date field in the query which is the record source for the report, it is not grouping according to previous report, as a investor may have different dates of reference . how can keep the report same and let the user select date range

[ranman256]

You can either:
put the dates in the query as a on demand parameter, ( it will as user every time)
or
use a form for the user to fill boxes and the qry reads this in the criteria...
select * from.....where [date] between forms!frmRpt!txtDateStart and forms!frmRpt!txtDateEnd

[JamesDeckert]

The easiest way is with the parameter query where the criteria row for the date field looks something like
>=CDate([>=Beginning Date]) And <CDate([<Ending Date])