date subtraction in query

[mejia.j88]

I have the following criteria for a date field:



Between ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtStartDate]) And ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtEndDate])

my date field is formatted as: Expr1: CDate(Format([glassing_yield].[date_time],"mm/dd/yyyy"))

i want the query to pull records from 4 days before the start time, i tried using adding a -4
Between ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtStartDate] - 4) And ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtEndDate])

error is my expression is typed incorrectly, or it is too complex to be evaluated. how can i do this substraction?

furthermore, if i want to get the data for 3/28/12, i have to put 3/28/12 as a start date, and 3/29/12 as an end date. Is there a way to modify this to where i would enter 3/28/12 as the start AND end date?

thanks guys

[Robeen]

Can you post a copy of the DB here?
It would be easier for me than trying to replicate your scenario.