Solved Filtering Query between 2 date

[theinviter]

Dear Guys,
Need help

i have q query having a date range
1- Date_From
2- Date_To

so wanna show the record from current date which are present between both date.

 

[oleronesoftwares]

SELECT DISTINCTROW Accounts.AccountNumber, Accounts.AccountName, Sum(Transactions.[DEBIT AMOUNT]) AS DEBIT, Sum(Transactions.[CREDIT AMOUNT]) AS CREDIT
FROM Accounts LEFT JOIN Transactions ON Accounts.AccountID = Transactions.AccountID
WHERE (((Transactions.TransactionDate)>=[forms]![Report Date Range]![Beginning Rpt Date] And (Transactions.TransactionDate)<=[Forms]![Report Date Range]![Ending Rpt Date]))

 

[Gasman]

I generally use the BETWEEN keyword for two dates in a query?