Re: SQL in Access Report

Thanks for the response.

I took your advice and tried the following code:

SELECT IIf([RPR]=True,"RPR",
IIf([MNT]=True,"MNT",
IIf([BAT]=True,"BAT","Unknown"))) AS GroupByThis,
[RPR],
[BAT],
[MNT],
*
FROM [T-SERVICE];

The repairs have grouped just fine, but the battery and maint will only
group with records that are not already displayed in the repairs group.

Any further advice?

.

Relevant Pages

  • Re: Key fobs - for central locking / alarm - Vauxhall
    ... I'd say that the advice that he gave ... you is part of the contract so you are within your rights to cancel. ... shame the shop. ... customer - asked how much to supply and fit a battery - he didn't ask ...
    (uk.legal)
  • Re: Key fobs - for central locking / alarm - Vauxhall
    ... I'd say that the advice that he gave ... shame the shop. ... fob that I got home and noticed it was designed to be opened - so I ... customer - asked how much to supply and fit a battery - he didn't ask ...
    (uk.legal)
  • Re: re:TV shows stripes/lines at the top of the screen
    ... period of time doing these repairs, inclusive of Sam, and many others. ... I am sorry you didn't consider my advice to be helpful, ... here and give the impression that they know nothing (as you did- you said ... If you read back over my posts you'll find that in actual fact I did give ...
    (sci.electronics.repair)
  • Re: Fibreglass repairs to transom of cat
    ... I've done similar repairs on cats in ... you better advice than i will. ... strength if you like by making an extra bulkhead or bulkheads. ... This adds plenty of strength. ...
    (rec.boats.building)
  • Re: do it yourself bike shop near Turby
    ... the UK is Elf 'n' Safety. ... We don't give advice and wouldn't. ... o giving bad advice about the need for repairs ... o failure to exercise due care to oversee on-premises repair technique ...
    (rec.motorcycles)