Monday Tuesday Wednesday Thursday Friday
Whirpool Whirpool Whirpool Whirpool Whirpool
Bellaire, Edward Rollande Quenneville Gale, Michael Commanda, Liz
Rollande Quenneville
Commanda, Elizabeth Charlebois, Leon Perselle, Gladys* Rainville,
Isabelle Belanger, Roger
Cross, Stella Foisy, Laura Collard, Alberta* Humphrey, Edna Gale,
Michael
Doucette, Rheaume Laframboise, Theodore Sills, Leroy Morin, George
Charlebois, Herman
Duhaime, Henry Richards, Marie-Joan Duhaime, Henry Cross, Stella
Ringuette, Maurice
Humphrey, Edna Morin, George Champagne, Laurette* Richards, Marie-Joan
Doucette, Rheaume
Rainville, Isabelle Belanger,Roger Showers Pellerin, Estelle Showers
Gravelle, Solange Pellerin, Estelle Amyotte, Marie-Jeanne* Bellaire,
Edward Bilodeau, Lillian
Showers Showers Foster, Eunice Gravelle, Solange Dobratz, Oscar
Argo, Betty Bilodeau, Lillian Fraser, Joe Showers Foisy, Laura
Bionda, Eric Dobratz, Oscar Girard, Florent* Argo, Betty Foster,
Eunice
Boissonneault, Victoria Ducharme, Yvonne Green, Rhoda* Bell, Janny
Lamothe, Marie-Jeanne
Connell, Harry Lefebvre, Margaret Howe, Bernice* Bionda, Eric
Lefebvre, Margaret
Girard, Jean McMartin, Eleanor Michaud, Romeo* Boissonneault, Victoria
Levesque, Lina
Larocque, Claude Miller, Lomer Reier, Felix Connell, Harry McMartin,
Eleanor
Groulx, Evelyne Proulx, Paul Stewart, Isabelle Girard, Jean Miller,
Lomer
Levesque, Lina Rose, Noella Ringuette, Maurice Proulx, Paul Chenier,
Emilia
Simpson, Theresa Lamothe, Marie Jeanne Hydrosound Simpson, Theresa
Rose, Noella
Tailleur, Florence Jodouin, Joffre Robinson, Patricia Tailleur,
Florence Therrien, Clara
Stewart, Duncan Lehman, Bert Fraser, Alice Dufont, Joseph Lehman, Bert
Dufont, Joseph Chenier, Emilia Independent Jodouin, Joffre Hydrosound
Hydrosound Hydrosound Ind. With supervision Stewart, Duncan Church,
Florence
Robinson, Patricia Church, Florence Leclerc, Joseph Groulx, Evelyne
Michaud, Rolland
KARL DEWEY said:
Just copy and paste a part of the Excel.
Barry McConomy said:
Karl
I get a feeling on what happening and ask if you can bear with me and
offer
further help.
I want the report to have the days across the top (Column Headings) and
then
the names under the day that their action is required.
The report is for a nursing home where the resident (name) decides when
they
want a bath, example some resident's have 7 baths per week others have 2,
also the resident will have a particular type of bathing.
I have a sample Excel listing if you would like me to send to you.
Regards
Barry
KARL DEWEY said:
What I posted was the SQL for a crosstab query. If you create a query
in
design view and click on menu View - SQL View you can paste my SQL in
the
query.
Is there a way to remove the Grand Totals from the view?
I do not know what you are looking at to answer.
:
Hi Karl
Thanks for replying.
I not sure what to do with this Code.
However, I did try creating a pivot table from a query and was able to
get
nearly what I wanted.
Is there a way to remove the Grand Totals from the view?
Regards
Barry
Is this what you want? You should not use "Day" as it is a reserved
word
in
Access.
TRANSFORM Last(YourTable16.Location) AS LastOfLocation
SELECT YourTable16.Type, YourTable16.Name
FROM YourTable16
GROUP BY YourTable16.Type, YourTable16.Name
PIVOT Format([Day of week],"w") & " " & Format([Day of
week],"dddd");
Or this with an added field to count --
TRANSFORM Count(YourTable16.X) AS CountOfX
SELECT YourTable16.Type, YourTable16.Name, YourTable16.Location
FROM YourTable16
GROUP BY YourTable16.Type, YourTable16.Name, YourTable16.Location
PIVOT Format([Day of week],"w") & " " & Format([Day of
week],"dddd");
:
Hi
I need a report that lists information is a column format like an
Excel
Worksheet.
In a query I have the following fields:-
Day: Monday, Tuesday, Wednesday etc.
Type: Type1, Type2, Type3 etc.
Name: Name
Location: Location
I would like the top row the have the Days across, then under each
day
I
would like the Type then under each type the Name & Location.
Can anybody help and give me direction on how I go about doing
this.
Regards
Barry