access中vba的小问题

[djwinter]

帮一个美女完成一个access数据库的作业时候,遇到了一个地方我认为要用vba的地方,但是完全不会,不知哪位大侠能够帮忙.
请联系[e-mail]
在线等待,多谢了

在这里描述不清楚,而且也不能上载文件:(

[OracleRoob]

上传到：
http://www.access911.net/csdn/

[djwinter]

http://access911.net/csdn/FileDescription.asp?mdb=2006-4-25&id=32

要求如下:
e) Write a query that will calculate the club’s profit or loss from when they started buying shares. You can implement this in SQL or in QBE. Explain how it works in your write up and include a print out of the results.
f) Write a query or VBA code that will reduce holdings in a certain company by a certain percentage which happens when the club decides to sell a number of shares. This query should NOT alter the bank balance (that happens when the club actually get the money from the broker). You may assume that the club always gets the current share price.
g) Write a query or VBA code that will allow the club to examine what will happen to their bank balance if they sell all or part of some of their shares. They will enter something like “BT” and 50% and the database will output how much money they will make from selling 50% of their shares in BT, and tell them their new bank balance. This query could be made more advanced by allowing the club to enter more than one share at a time such as: “BT”, 50%, “EasyJet”, 30%, etc. You may assume that the club always gets the current share price. You may or may not wish to take the brokers fees into account. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
h) Write a query or VBA code that will calculate how much each member would get if the club was dissolved i.e. the amount in the bank, plus the money that would be raised by selling all shares, divided by the number of members in the group. You may assume that the club always gets the current share price. You should produce a report formatted in a suitable way that details this information, along with how much the broker would be paid. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
i) Add additional queries/reports as you think useful.
j) Write a description and/or pseudo code of an algorithm that will give the club a buy / don’t buy / sell / hold decision for each of the shares that are have been identified as being of interest to the group. (This is historically a very tricky problem and there

[djwinter]

http://access911.net/csdn/FileDescription.asp?mdb=2006-4-25&id=32

要求如下:
e) Write a query that will calculate the club’s profit or loss from when they started buying shares. You can implement this in SQL or in QBE. Explain how it works in your write up and include a print out of the results.
f) Write a query or VBA code that will reduce holdings in a certain company by a certain percentage which happens when the club decides to sell a number of shares. This query should NOT alter the bank balance (that happens when the club actually get the money from the broker). You may assume that the club always gets the current share price.
g) Write a query or VBA code that will allow the club to examine what will happen to their bank balance if they sell all or part of some of their shares. They will enter something like “BT” and 50% and the database will output how much money they will make from selling 50% of their shares in BT, and tell them their new bank balance. This query could be made more advanced by allowing the club to enter more than one share at a time such as: “BT”, 50%, “EasyJet”, 30%, etc. You may assume that the club always gets the current share price. You may or may not wish to take the brokers fees into account. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
h) Write a query or VBA code that will calculate how much each member would get if the club was dissolved i.e. the amount in the bank, plus the money that would be raised by selling all shares, divided by the number of members in the group. You may assume that the club always gets the current share price. You should produce a report formatted in a suitable way that details this information, along with how much the broker would be paid. Submit a print out of your SQL/QBE/VBA code with comments to explain how it works.
i) Add additional queries/reports as you think useful.
j) Write a description and/or pseudo code of an algorithm that will give the club a buy / don’t buy / sell / hold decision for each of the shares that are have been identified as being of interest to the group. (This is historically a very tricky problem and there