I have an access 97 database and I need to generate a report to display the last 24 hours data entry. That's to say if the time is 10am when the report is execute, The report should display all the records entered since yesterday at 10am. If I execute the report at 6pm. The report should display all the records entered ince yesterday at 6pm.
Please help me out with the sql commands or another way to do this in access 97.