Search results

I have a table called FundLedger. The primary key field is FundLedgerUID. Other fields I am using are AccountID, GiftReceivedDt, and DeductibleDonationAmt. I am trying to write a query that will give me the FundLedgerUID for the earliest GiftReceivedDt for each AccountID. The reason I have to...

Still working on this. I will get back to you.

Thanks for the quick reply! I may want to put it in a table eventually, but for now you're right, the query will calculate it every time and that's fine. The Account # is an Integer, the Fiscal Year is a 4-digit year that was extracted from the GiftReceivedDt Date field. Total is a currency...

I have a query with 4 fields - Account #, FiscalYear, GiftReceivedDt, and Total. This is a list of donations that people have given to the college where I work. Each row has the account # of the giver, the fiscal year in which it was given, the exact date it was entered, and the amount given. I...

I am a musician by trade, but I learned to use Access at an Office job by necessity and got very good at relational database design and thinking - tables, queries, forms, reports, and macros. Now I have some side work for my current employer (a small college) mining our current database using...