日历控制并列出最后5笔付款 [英] Calender control and listing last 5 payments made
问题描述
早上好，
我正在建立一个数据库来跟踪村民因购买太阳能电池板而支付的费用。规则是每个月可以少量支付。现在我想要的是如何显示特定村民的最后5笔付款。
例如。
太阳能灯的成本是卢比。 3000
初始付款 - 500
余额 - 2500卢比
下个月
- 500
nex - 500
next 100
next 200
所以如果用户想要生成报告以查看最后5笔付款由一个村民做，扫管笏我做...我定义一个数组，我如何在表中设计一个字段...
其次，我如何添加一个日历控制在一种形式。
提前谢谢
Sajit
Good morning,
I am making a database to keep track of payments made by villagers on account of purchasing solar lanters. the rule is the payment can be made in small amounts each month. now wat i want is how do i show the last 5 payments made by a particular villager.
for eg.
cost of the solar lantern is Rs. 3000
initial payment made - 500
balance - Rs 2500
next month - 500
nex - 500
next 100
next 200
so if the user wants to generate a report to see the last 5 payments made by a villager, wat do i do...do i define an array and how do i design a field in the table...
secondly, how do i add a calender control in a form.
thanks in advance
Sajit
推荐答案
你只需要使用一个返回的子查询一个SELECT TOP 5.
You just need to use a subquery that returns a SELECT TOP 5.
你只需要使用一个返回SELECT TOP 5的子查询。
You just need to use a subquery that returns a SELECT TOP 5.
我在哪里写这个子查询....我如何设计我的表。我将其存储在一个字段中，还是将值存储在5个不同的字段中。
并且在表格中，我是否使用数组来存储这些值......
只是更具体一点这个数量请。
如何加入日历控件....
提前致谢
where do i write this subquery....and how do i design my table. do i store this in one field or do i store the value in 5 different fields.
and in the form, do i use an array to store these value.....
just be more specific on this count please.
How do i incorporate a calender control....
Thanks in advance
Sajit ，
你需要把你的问题放在不同的主题中。
我们将处理这一期中的最后5笔付款，因为我对日历一无所知控制。
为了告诉你如何从你的桌子中选择你需要的东西，我们需要你告诉我们你的桌子是如何布置的。
请以下面的形式提供表元（从答复屏幕复制并粘贴以获得帮助）。
Sajit,
You need to put your questions in separate threads.
We''ll deal with the last 5 payments in this one as I know nothing about Calendar controls.
To tell you more about how to select what you need from your table(s) we need you to tell us about how your tables are laid out.
Please provide table meta in the following form (copy and paste from the reply screen for help with that).
这篇关于日历控制并列出最后5笔付款的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
