Date Range Query Not Returning Correct Results

[sallen]

I am using the following SQL Statement in my Access Query.
SELECT [PrincipalPayments].[AccountNumber ], [PrincipalPayments].
[PmtPostDate], [PrincipalPayments].[PrincPmtAmt], [Account].
[FirstPmtDefault]
FROM Account INNER JOIN PrincipalPayments ON [Account].
[AccountNumber]=[PrincipalPayments].[AccountNumber ]
WHERE ((([PrincipalPayments].[PmtPostDate])>=[Enter Start Date] And
([PrincipalPayments].[PmtPostDate])<[Enter End Date]) And (([Account].
[FirstPmtDefault])=False));

The date range criteria works when the date range is with in the same
year all though when I select a range such as 08/01/2006 to 01/30/2007
it either doesnt return any records or returns all records. Please
help.

 

[Jerry Whittle]

Try 01/08/2006 to 30/01/2007 .

SQL is an ANSI standard and guess what the A is for?????

Other than that, is the PmtPostDate field date/time or text?

 

[sallen]

I figured it out.. Of course a simple over sight on my part. I had the
field as text instead of date.. Thanks for reminding me to check.