Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Aug 29 09:05:22 CDT 2007
Arthur: I'd try: TransactionDate >= #03-Jul-07# AND TransactionDate <= #03-Jul-07# Will the two dates always e the same or will there mostly be a range. Also, try removing the date filter to see what's being returned. Could it be that there are no records with July 3, 07? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, August 29, 2007 3:38 AM To: Access Developers discussion and problem solving Subject: [AccessD] Date-scoping It's been a long while since I've done an MDB-BE and it's amazing how much one forgets. I'm trying to date-scope a report. I've got a little form that asks for start and end dates, and the result is being passed in like this: (TransactionTypeID= 2 AND TransactionDate BETWEEN #03-Jul-07# AND #03-Jul-07#) This is not working. What am I doing wrong? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.10/977 - Release Date: 8/28/2007 4:29 PM