Re: How do I "Group by" more than 1 field in a query?

Apologies, I misunderstood your post.

Group by Address, and select First instead of Group By so that you only get
an ID number once per address. (Last, Max and Min would also achieve the
same result.)


..
"David F Cox" <nospam@xxxxxxxxxx> wrote in message
news:O0kg%23Oc%23GHA.4464@xxxxxxxxxxxxxxxxxxxxxxx
If you are grouping by ID you will get one record per ID. (Been there -
Duuuh)

Just group by address. Be prepared for Addresses not to match because of
the smallest differences, like an extra space somewhere.

"SquirrelToothAnnie" <SquirrelToothAnnie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:0519F6DF-BFC1-4C58-BDC6-4F0BA89CACB1@xxxxxxxxxxxxxxxx
I'm trying to group by ID No' , then by address so that multiple IDs at
the
same address will only appear once in the query results. Please answer
clearly as I'm fairly new to this. Many thanks






.

Relevant Pages

  • Re: PC Cameras and SP2
    ... but what I visualize as a simple query always seems ... >> that's why he mentions Windows Messenger vs. MSN Messenger. ... > seems to be misunderstood. ...
    (microsoft.public.windowsxp.basics)
  • Re: Yaris diesel head gasket failure
    ... > Apologies from a newbie to this group. ... However, my query is this: ... > warranty, and I would have expected them to do the job for free if it was ... Once the vehicle is out of warranty, ...
    (alt.autos.toyota)
  • Re: Criteria - show records in text field1 based on a yes/no field
    ... misunderstood your 1st response as I have never used a calculated expression. ... And my thanks to Karl as I suspect I also misunderstood your suggestion. ... "John Spencer" wrote: ... In design view (the query grid), you would see something like the following ...
    (microsoft.public.access.queries)
  • Yaris diesel head gasket failure
    ... Apologies from a newbie to this group. ... I realise my query may not be relevant to this group, ... The head gasket recently failed on my Yaris diesel. ... Is this a known fault on these engines? ...
    (alt.autos.toyota)
  • Re: Automatic field filling
    ... The general principle, in the example you gave, is that the second table ... Apologies ... name by reference to the first table, so it is redundant to store this ... last name fields form the first table directly into the query, ...
    (microsoft.public.access.tablesdbdesign)
Loading