Re: Total Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

John,


Thank You,

Greg
"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3nf4r295crsoerqjh2gletto4ou98hljks@xxxxxxxxxx
On Sat, 20 Jan 2007 01:19:06 -0500, "Greg" <gfjesky@xxxxxxxxxxxxx>
wrote:

Jason and John,

Thank you- Max works great! John can you explain when I would possibly
get
"(which might have
some fields from one record and some fields from another)" ?

If you JUST use a Totals query, the [Current Charges] or [Billing
Code] field will need to either be in the Group By - which will give
you one record per different value of the charges and code rather than
the most recent - or some other aggregate function such as Max. That
would give you (e.g.) the latest date (from the Max of date) and -
*independently* - the largest charge anywhere in the table (from the
Max on the charge).

The subquery is unambiguous - it will find the latest record and
display all the fields from that record.

John W. Vinson[MVP]


.

Relevant Pages

  • Re: Maybe Cops Shouldnt Throw THEIR Weight Around
    ... Just four years before John Bad Elk, the Supreme Court of the United States ... I wouldn't count on it if I had to shoot a cop. ... No charges over handcuffed teen's death Jessica Marszalek ...
    (rec.gambling.poker)
  • Re: CCW Nightmare in Canton, Ohio
    ... # the prosecutor offered to drop all charges in return for a promise not ... =A0That group has set up a way ... # to donate to his defense costs, similar to what a VA group is doing ... =A0I initially read a link from John Lott's ...
    (rec.guns)
  • Re: Total Query
    ... If you JUST use a Totals query, the [Current Charges] or [Billing ... The subquery is unambiguous - it will find the latest record and ... display all the fields from that record. ... John W. Vinson ...
    (microsoft.public.access.queries)
  • Re: Road rager v. cyclist on camera
    ... john wrote: ... Driver throws litter out window. ... The cops should have charged them both. ... > someone w/ five charges describing the same offence. ...
    (rec.bicycles.tech)
  • Re: Executors - Can these be changed after death by relatives?
    ... John L writes are most likely to use in-house staff. ... Your input or objection is limited ... to trying to keep their charges down to what is reasonable. ...
    (uk.legal)