SQL in Access Report

I have one table used to maintain information on Service Events.
Each record contains a Repair, Maint, and Battery checkbox
(bound/boolean). Any one of these fields may be checked or left empty.
Ex. REPAIR=True, MAINT=False, BATTERY=True

I want to generate ONE report that lists all the REPAIRS, then lists
all the MAINT, and then lists all the BATTERY events. One group after
the other in the same report. Because (ex. REPAIR and BATTERY) may
both be true in the same record, the record will appear 2 times in the
report, once in the REPAIR group and once in the BATTERY group.

I am not sure how to approach this. I'm new to SQL. I' m using MS
AccessSQL.

I Tried the following code, but the results are not sorting properly
and not grouped.

SELECT * FROM [TABLE1] WHERE [REPAIR]
UNION ALL
SELECT * FROM [TABLE1] WHERE [MAINT]
UNION ALL
SELECT * FROM [TABLE1] WHERE [BATTERY]

.

Relevant Pages

  • Re: SQL in Access Report
    ... Now the report is set up to group each GroupByThis value. ... Each record contains a Repair, Maint, and Battery checkbox ...
    (comp.databases.ms-sqlserver)
  • Re: Report: Grouped by Fields
    ... Each record contains a Repair, Maint, and Battery checkbox ... I want to generate one report that lists all the Repairs, ... If you have multiples (battery and Repair for example on 1 record) then you might be best to create a UNION query for the report recordsource. ...
    (comp.databases.ms-access)
  • Re: Repairing a dead Sola 325 UPS 750Ah
    ... Conversly, if the battery backup part had failed, it had ... Removing the circuit board involves unplugging a lot of leads. ... Removing the existing FETs is best achieved by cutting them off, ... http://www.divdev.fsnet.co.uk/repair.htm Repair Briefs- VCRs,TVs,Monitors ...
    (sci.electronics.repair)
  • Re: OT - AVO help needed.
    ... This move was viewed with disdain as it made them a swine to repair and they were prone to cracking solder joints on the PCB which was curved around the components. ... soot inside the glass dial and a non-working Avo! ... I fitted it with a new 1.5 volt "A" battery was surprised to find no response from any setting, the first time I've found an AVO meter that didn't work! ... It is one of those that requires an additional fifteen volt battery & I don't have one of course. ...
    (uk.rec.engines.stationary)
  • Re: Try this with your Mac portable!
    ... not run on the battery, nor was the battery taking a charge. ... found that the screw holding the battery connector to the motherboard ... You don't repair PC's?desktops ... world could, well, be a place with working HD's in all laptops. ...
    (comp.sys.mac.advocacy)