Politics & Current Events
gpointewife
member
You know how we do
Dear Community,
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
I am working on my final Access project and I need help...
Anyone? I am stuck on creating a calculated field.... I have a link to the question if anyone can help.
Desperation has set in.
You know how we do
Re: I am working on my final Access project and I need help...
Here is the link:
Clicky
Page 3, question 9.
I know they want totals of all the investments listed by name (instead of one by one by name), but I can't seem to get there.
The "total investment" field that they're speaking of is just one entry on a particular date. For instance, someone may have an investment today and again in another week. Does that make sense?
You know how we do
So, it looks like they want a summary query where you group on the name (so it would only show one entry for "John Smith") and then you sum on the InvestmentAmt field to get his total investment. Try this SQL:
SELECT tblMember.FirstName, tblMember.LastName, Sum(tblContribution.InvestmentAmt) AS [Total Investment]
FROM tblContribution INNER JOIN tblMember ON tblContribution.MemberID = tblMember.MemberID
GROUP BY tblMember.FirstName, tblMember.LastName
ORDER BY Sum(tblContribution.InvestmentAmt) DESC;
If you are in query design, you can select SQL View (it's on the top left for me - next to Run) and paste the above in. Then you can go back to design view and see it that way.
Let me know if that works and if you need help with part 2 of the question.
ok...I got that part, and I got the last...
Can I keep you on standby, lol?
You know how we do
I'm happy to try to help....
Sibil - she didn't need SQL, but it is an easy way for me to pass the query that I used along. She just needed a simple summary query (I think the crosstab query was one of the next questions - those aren't my favorite!)