What is the correct syntax to write a query for a certain amount of time?<BR><BR>For example I hve found all kinds of documentation on how to ask for a certain period of time like this WHERE Time(dateTimeField) BETWEEN #whenever# AND #whenever#<BR><BR>But I need to ask for records created between 7 days ago and right now nomatter when right now happens to be.