Starter Questions

[JimmyRayBob]

Hi Everyone.



I am BRAND NEW to Access, and while i'm pretty good with computers in general, i don't have any experience programming or with Access.

I am starting a new database from scratch - it will begin with one table of contacts (shareholders) and the number of shares they own in several businesses. I would like access to calculate the %age of ownership in each company. Very easy in Excel, but after hours of searching these forums and elsewhere, I am at a loss.

Name #Shares %age
Jim 15 xx%
Bob 33 yy%
Tom 27 zz%
Total 75 100%

Pretty straight-forward I think. Should i be doing this in a Query? And if so, how?


2nd Quesiton:
We have about 25 companies, and i want all the reports to look the same. Is there a way to have a button in a form so when i click on the button, i get a list of queries to run (for example, all shareholders with >0.1 shares of a company X), and then have that list automatically go into a Report?

Thanks in advance.

Jim

[Stingaway]

First part - yes, do it in a query. Typically for these I have a ship in a bottle approach, where I first calculate the totals and then use two queries to get what I want. Here is an example:

SELECT tmp_tbl_Demo.Person_Name, tmp_tbl_Demo.Person_Shares, qry_Totals.SumOfPerson_Shares, [Person_Shares]/[SumOfPerson_Shares] AS Expr1
FROM tmp_tbl_Demo, qry_Totals;

The totals query looks like this:
SELECT Sum(tmp_tbl_Demo.Person_Shares) AS SumOfPerson_Shares
FROM tmp_tbl_Demo;



I created a temp table with what you had above, created a query to total it, then another query to compare the data. It sounds complicated, but it's not really.. It is one of those times where I generally would use Excel just for ease of use (and I can do it a lot faster that way), but you can still get the same result in your query. Also, if you turn on your totals in the query view, you can see exactly what you would in Excel.

Second question: Yes. What you mention is very do-able. I have many databases that are simply report databases that provide a similar function.

Hope this helps.

[JimmyRayBob]

Stingaway ... thanks for the quick response. I will take a look at this soon (when i get caught up on other projects).

Jim