Date range problem

[seke]

I'm using the following to obtain a date range of records

Sum(IIf([ACDateRec] Between [Forms]![frmDiaryMain]![UBDATESTART] And [Forms]![frmDiaryMain]![UBDATEEND],[GROSSTOTAL],0))

However the search fails to find all records between dates.

I wish to change the above so rather than use Between I use

Sum(IIf([ACDateRec] >=[Forms]![frmDiaryMain]![UBDATESTART] And <[Forms]![frmDiaryMain]![UBDATEEND],[GROSSTOTAL],0))

Problem Access is happy with >= but produces a syntax error message when I enter the < after the "AND"

Help would be nice.

S.Eke (aka Half way up a wall trying to get it to work)

 

[SkipVought]

Hi,

Sum(IIf([ACDateRec] >=[Forms]![frmDiaryMain]![UBDATESTART] And [b][ACDateRec][/b]<[Forms]![frmDiaryMain]![UBDATEEND],[GROSSTOTAL],0))

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[seke]

Skip

Thanks

"Looks like I Could not see the wood for the trees"

Works a treat.

S.Eke

 

[SkipVought]

ahhhh, the selection of cellulite to sore sight.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}