Re: Help on a query based on the latest date

From: Joe Cilinceon (jfc_at_direcway.com)
Date: 10/31/04 

Date: Sun, 31 Oct 2004 14:54:46 -0500

Well I may have spoke too soon. It works with the Unit, Tenant and PaidThru
fields but will not work when adding the rest of the record in the table.
For example if I add the DatePaid field to the query in now duplicates a
unit/tenant combo. I'm looking to get the whole record to show as I'll be
working with all that data once it is queried. I hope that was a clear
explanation as I'm starting to get confused myself. g 

-- 
Joe Cilinceon
"Joe Cilinceon" <jfc@direcway.com> wrote in message
news:emYRjB4vEHA.612@TK2MSFTNGP15.phx.gbl...
> Thanks that worked.
>
> -- 
>
> Joe Cilinceon
>
>
> "PC Data***" <nospam@nospam.spam> wrote in message
> news:4_ahd.13859$5i5.306@newsread2.news.atl.earthlink.net...
> > Create a query that includes only the fields Unit, Tenant and
> PaidThruDate.
> > While in query design view, click on the Sigma (looks like E) button on
> the
> > toolbar at the top of the screen. Then under PaidThruDate, change Group
By
> > to Max. This query should give you what you want.
> >
> > --
> >                                         PC Data***
> > Your Resource For Help With Access, Excel And Word Applications
> >                               resource@pcdata***.com
> >                                  www.pcdata***.com
> >
> >
> >
> > "Joe Cilinceon" <jfc@direcway.com> wrote in message
> > news:Oy6g403vEHA.2728@TK2MSFTNGP12.phx.gbl...
> > > Hi
> > >
> > > This is my first time posting here and need some help, please. I have
a
> > > table (Ledger) that stores payment information on units/tenants at a
> > storage
> > > facility. The table has a transaction number (autonumber) on every
entry
> > as
> > > well as the unit number, tenant ID # (multiple possible per table) as
> well
> > > as all the information on the payment made such as date, amount,
method
> > etc.
> > > I also have a field for PaidThru (date) which gives the final date the
> > rent
> > > will cover. Hence, there will be several records for each unit as well
> as
> > > different tenants for units time goes by (they move out and other move
> in
> > > constantly).
> > >
> > > Now here is the problem I want a query that will only show the last
> > paidthru
> > > date based on a given unit/tenant combination. Any help would be
greatly
> > > appreciated.
> > >
> > > --
> > >
> > > Joe Cilinceon
> > >
> > >
> > >
> >
> >
>
>