Query Help, thanks!
Greetings!
Please see my data below, for each account, I would need the lastest
balance_date with the corresponding balance. Can anyone help me with
the query? Thanks a lot!
create table a
(account int
,balance_date datetime
,balance money)
insert into a values(101,'1/31/2005', 5000)
insert into a values(101,'2/28/2005', 6000)
insert into a values(102,'5/31/2005', 15000)
insert into a values(102,'6/30/2005', 10000)
Ideal Output
101 '2/28/2005' 6000
102 '6/30/2005' 10000
.
Relevant Pages
- Re: Looped result
... The rows returned in a query cannot ... Beginning Balance would start over at zero for a new account. ... Because there can typically be multiple transactions on the same date, ...
(microsoft.public.access.queries) - Re: Creating a balance sheet form
... You can do this in a report fairly easily by using the property RunningSum. ... you'll want to create a query to feed the form. ... account and savings account debits and credits. ... on the account balance. ...
(microsoft.public.access.forms) - Re: How to get a running balance total
... You won't have transactions for every day for every account. ... Create a Cartesian product query based on this table of dates and your Accounts table ... do a quick add for a total balance for the month, ... > withdrawals for an account involved in a specific investment. ...
(microsoft.public.access.queries) - calculating results within a query
... I need to check the balance of an account during reporting periods (13 ... I have devised a query to do this. ... (ALL AMOUNTS ARE FICTIONAL!) ...
(microsoft.public.access.queries) - Re: AR ageing 120
... "Balance Forward" that being the balance as it was at the end of the ... applied against the invoices, so every invoice has an unpaid balance. ... them together to show the current balance of the account. ... Never set up a crosstab query in access ...
(microsoft.public.access.queries) |
|
