Query using boolean and greater than >

[antm2209]

Hi,

I am trying to create a query that will display records where the boolean is set to no and when daysrent is greater than 1 when i open the query up

The boolean name is td_Returned

Daysrent: DateDiff("d",[tm_dateout],Now())

Is there something i need to put into one of the criteria to just display boolean = no and everything over 1.

something like this maybe - if (td_Returned=No) AND (daysrent >1) I know thats not right just to show you what i am trying to do. I have included a screen shot if that helps

http://cid-bf7cdf43432e428e.skydrive.live.com/self.aspx/Public/query.jpg

Any help would be brilliant, Thanks

 

[PWise]

select ....
from tablename
where (td_Returned=No) AND (DateDiff("d",[tm_dateout],Now()) >1)

 

[Golom]

If you show the SQL pane rather than the Query Designer, that would be more helpful.

You probably want a WHERE clause like

WHERE td_Returned = FALSE AND daysrent > 1

 

[antm2209]

Thank you so much for your time all sorted