Query with or criteria on date range

[jamphan]

I have 2 fields in my query called dtmDateRequested and dtmDateRequestComleted. When I run my query I would like for it to pull in all accounts that have either a Request Date which I specify or also a Completion Date in the same range. I have tried using the Between [Enter Begin Date] for the criteria and or criteria and also tried linking the criteria to a form with date range fields but it returns that the expression is too complex. Thanks for any help with this.

 

[JMG]

If I understand what you are doing--you are putting a criteria on both fields--this may be the problem.

 

[jamphan]

That is correct, however it is the same criteria. I need to see all account either received or completed in the same time frame. Is there a work around?

 

[JMG]

If I understand -- you want to see what has been scheduled and completed between dates. Just put your criteria on the scheduled field and if it is completed it will have a date in the completed field. If it is still open it will be blank.
Sorry for the delay in posting - wild at work.

 

[WayneRyan]

jamphan,

Just put the criteria on different rows in the query grid. That will make it
an OR condition. If they're on the same row, it is an AND condition.

Wayne