I am new to SQL. In SQL 2000 I need to create a query that returns data from a specific table within a specific date and time range. For example, the range would be 4:00AM 5/30 to 3:59AM 5/31. The report will be sent to run at 4:00 AM daily and needs to include all transactions from the past 24 hours. So from 4:00 AM 5/30 thru 3:59 AM 5/31. I would like to set the query so that every day that the report is run I don't have to change the query.