Access 2007 Tutorial How to Create A Table Using SQL

[ashyxt]

THANK YOU VERY MUCH SIR!

this is very useful for class skipper like me

oops = P

[Jude1212223]

@ashyxt You are very welcome.

[Jude1212223]

Thanks to you as well !!!

[snipermen23]

thanks you very much

[Jude1212223]

Thank you so very much.

[SsikG]

your wonderful! A slow and steady tutorial was excellent :)

and like you said Praise the LORD at the end

AMEEN!

[Jude1212223]

Try using the Cross-Tab Query Wizard. This should show each name, shares, and (sum) total shares all on one row.

[getownedn00b]

Can someone PLEASE ANSWER MY QUESTION!

I have 3 tables, one for people, one for company, and one for transactions. The transaction table uses a lookup menu to select the person and the company, then you input the number of shares bought or sold for that person. I want to have a report or query or whatever that shows everyones name, and how many shares they have in total. BUT heres my problem.. how do i add up all the shares that belong to one person and not another?And then show this data?