<div>
Thank you, thats the conclusion I came to but I am not getting any results returned, and I know I should as my Oracle query returns the correct results.
</div>


Thank you, thats the conclusion I came to but I am not getting any results returned, and I know I should as my Oracle query returns the correct results.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I need to write the following query in Access:<br />
<br />
I have a table called Loan, <br />
I need to total the number of installments owing for a particular month or year where the balance is greater than zero, my problem being I don't know how to use the date functionality in Access the query needs to work in both 97 and 2000 but more importantly in 97.<br />
I have the query I wrote in Oracle just quickly to get the results for June so that I could compare my Access results to ensure when I get the query in Access going my results are correct:<br />
<br />
select sum(installment) Total from loan<br />
where nextpaymntdate &gt;&nbsp;last_day ('01-MAY-01')<br />
and nextpaymntdate &lt;= last_day('01-JUN-01')<br />
and balance &gt;&nbsp;0;<br />
<br />
I would like to get the user to enter the month or year they need the data from and the query to bring up just that month or year the user has chosen. &nbsp;The date in Access format is e.g. 1-6-01.<br />
<br />
If you can help a busy person it would be most appreciated
</div>
</div>


Hi,
I need to write the following query in Access:

I have a table called Loan, 
I need to total the number of installments owing for a particular month or year where the balance is greater than zero, my problem being I don't know how to use the date functionality in Access the query needs to work in both 97 and 2000 but more importantly in 97.
I have the query I wrote in Oracle just quickly to get the results for June so that I could compare my Access results to ensure when I get the query in Access going my results are correct:

select sum(installment) Total from loan
where nextpaymntdate > last_day ('01-MAY-01')
and nextpaymntdate <= last_day('01-JUN-01')
and balance > 0;

I would like to get the user to enter the month or year they need the data from and the query to bring up just that month or year the user has chosen.  The date in Access format is e.g. 1-6-01.

If you can help a busy person it would be most appreciated

Urgent Date Question

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.