Horizontal lines

  • Thread starter Thread starter AGOKP4
  • Start date Start date
A

AGOKP4

Hi,

I am trying to insert lines in a report I created from a Union query. There
are 5 groups in all and I would like to have lines demarcating them.

Any other suggestiuons would be welcomed also.

THANKS!!!
 
Did you sort/group on your "5 groups"? If so, it seems you could create a
group header or footer section with a line control.
 
Hello Duane,

I pasted my query below. They were not sorted, I created each query
separately before combing with the union query


GROUP BY [Enrolled Qry].Sex;

UNION ALL
SELECT "Race" as Source, [Enrolled Qry].Race, Count([Enrolled Qry].Race) AS
CountOfRace
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Race;

UNION ALL
SELECT "Ethnicity" as Source, [Enrolled Qry].Ethnicity, Count([Enrolled
Qry].Ethnicity) AS CountOfEthnicity
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Ethnicity;

UNION ALL
SELECT "Tenofovir" as Source, [Enrolled Qry].Tenofovir, Count([Enrolled
Qry].Tenofovir) AS CountOfTenofovir
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Tenofovir;

UNION ALL SELECT "Creatinine Group" as Source, [Enrolled Qry].[Creatinine
Group], Count([Enrolled Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].[Creatinine Group];
 
Create a sorting and grouping level on [Source] and display it's Footer
section.
Add a horizontal line in the Source group footer.

--
Duane Hookom
Microsoft Access MVP


AGOKP4 said:
Hello Duane,

I pasted my query below. They were not sorted, I created each query
separately before combing with the union query


GROUP BY [Enrolled Qry].Sex;

UNION ALL
SELECT "Race" as Source, [Enrolled Qry].Race, Count([Enrolled Qry].Race) AS
CountOfRace
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Race;

UNION ALL
SELECT "Ethnicity" as Source, [Enrolled Qry].Ethnicity, Count([Enrolled
Qry].Ethnicity) AS CountOfEthnicity
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Ethnicity;

UNION ALL
SELECT "Tenofovir" as Source, [Enrolled Qry].Tenofovir, Count([Enrolled
Qry].Tenofovir) AS CountOfTenofovir
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Tenofovir;

UNION ALL SELECT "Creatinine Group" as Source, [Enrolled Qry].[Creatinine
Group], Count([Enrolled Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].[Creatinine Group];

Duane Hookom said:
Did you sort/group on your "5 groups"? If so, it seems you could create a
group header or footer section with a line control.
Click to expand...
Click to expand...
 
Thanks Duane...it worked

Duane Hookom said:
Create a sorting and grouping level on [Source] and display it's Footer
section.
Add a horizontal line in the Source group footer.

--
Duane Hookom
Microsoft Access MVP


AGOKP4 said:
Hello Duane,

I pasted my query below. They were not sorted, I created each query
separately before combing with the union query


GROUP BY [Enrolled Qry].Sex;

UNION ALL
SELECT "Race" as Source, [Enrolled Qry].Race, Count([Enrolled Qry].Race) AS
CountOfRace
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Race;

UNION ALL
SELECT "Ethnicity" as Source, [Enrolled Qry].Ethnicity, Count([Enrolled
Qry].Ethnicity) AS CountOfEthnicity
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Ethnicity;

UNION ALL
SELECT "Tenofovir" as Source, [Enrolled Qry].Tenofovir, Count([Enrolled
Qry].Tenofovir) AS CountOfTenofovir
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].Tenofovir;

UNION ALL SELECT "Creatinine Group" as Source, [Enrolled Qry].[Creatinine
Group], Count([Enrolled Qry].[Creatinine Group]) AS [CountOfCreatinine Group]
FROM [Enrolled Qry]
GROUP BY [Enrolled Qry].[Creatinine Group];

Duane Hookom said:
Did you sort/group on your "5 groups"? If so, it seems you could create a
group header or footer section with a line control.
--
Duane Hookom
Microsoft Access MVP


:

Hi,

I am trying to insert lines in a report I created from a Union query. There
are 5 groups in all and I would like to have lines demarcating them.

Any other suggestiuons would be welcomed also.

THANKS!!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top