MySQL Forums
Forum List  »  Microsoft Access

Access queries
Posted by: freddie
Date: April 28, 2005 02:41AM

I am trying to replicate queries in access through mySQL query Editor and have come to a bit of a brick wall. In access i need queries that run off other queries. as if they were tables.

I am creating a portfolio management system. I use the trade list to create a list of the stocks we hold. this trade list will include the prices and thus the value of our holding. The problem comes when i need to calculate the allocations - the percentage each stock is to the fund. I need to calulated the sum of the values of each stock and then run the query again to divide the value of a stock by the total value of the portfolio.

In access i just run the stock holdings query and include that query twice in the second query.

How can i perform the same task in mSQL?

Thanks,

Freddie

Options: ReplyQuote


Subject
Views
Written By
Posted
Access queries
2444
April 28, 2005 02:41AM
1596
April 29, 2005 10:47AM
1611
May 02, 2005 05:28AM
1575
May 04, 2005 08:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.