If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
I have a report based off of a crosstab query that the data under the columns
is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#2
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
It would help if you provided some values from the Rank field in the order
you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#3
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
Yes they are numbers and it starts at 1 example of what it looks like:
Rank Column1 Column2 1 WED5700 White WGD6400 White 2 WED6400 White Where exactly would I put the =Val([Rank]) in the report? Thank you so much for your help..... -- Alison "Duane Hookom" wrote: It would help if you provided some values from the Rank field in the order you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#4
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
Put it where "I have the rank (count) in the report under the grouping section"
I assume this is the sorting and grouping dialog in report design. -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: Yes they are numbers and it starts at 1 example of what it looks like: Rank Column1 Column2 1 WED5700 White WGD6400 White 2 WED6400 White Where exactly would I put the =Val([Rank]) in the report? Thank you so much for your help..... -- Alison "Duane Hookom" wrote: It would help if you provided some values from the Rank field in the order you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#5
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
It didn't work, do I need to replace the control source with it, or just put
it in the grouping and sort dialog box? -- Alison "Duane Hookom" wrote: Put it where "I have the rank (count) in the report under the grouping section" I assume this is the sorting and grouping dialog in report design. -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: Yes they are numbers and it starts at 1 example of what it looks like: Rank Column1 Column2 1 WED5700 White WGD6400 White 2 WED6400 White Where exactly would I put the =Val([Rank]) in the report? Thank you so much for your help..... -- Alison "Duane Hookom" wrote: It would help if you provided some values from the Rank field in the order you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#6
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
What exactly do you have in the sorting and grouping dialog?
Is the Rank field left or right aligned in the datasheet view? Are there any lookup fields in your tables? -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: It didn't work, do I need to replace the control source with it, or just put it in the grouping and sort dialog box? -- Alison "Duane Hookom" wrote: Put it where "I have the rank (count) in the report under the grouping section" I assume this is the sorting and grouping dialog in report design. -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: Yes they are numbers and it starts at 1 example of what it looks like: Rank Column1 Column2 1 WED5700 White WGD6400 White 2 WED6400 White Where exactly would I put the =Val([Rank]) in the report? Thank you so much for your help..... -- Alison "Duane Hookom" wrote: It would help if you provided some values from the Rank field in the order you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#7
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
I have the following three items in the dialog box before the rank that are
grouped with a header, the rank does not have a header It reads like: PrimaryID Ascending (Grouped with Header) Category Description Ascending (Grouped with a Header) Category Detail Ascending (Grouped with a Header) Rank Ascending (No Header) The Rank field shows to be left aligned. None of the tables have a look up field -- Alison "Duane Hookom" wrote: What exactly do you have in the sorting and grouping dialog? Is the Rank field left or right aligned in the datasheet view? Are there any lookup fields in your tables? -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: It didn't work, do I need to replace the control source with it, or just put it in the grouping and sort dialog box? -- Alison "Duane Hookom" wrote: Put it where "I have the rank (count) in the report under the grouping section" I assume this is the sorting and grouping dialog in report design. -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: Yes they are numbers and it starts at 1 example of what it looks like: Rank Column1 Column2 1 WED5700 White WGD6400 White 2 WED6400 White Where exactly would I put the =Val([Rank]) in the report? Thank you so much for your help..... -- Alison "Duane Hookom" wrote: It would help if you provided some values from the Rank field in the order you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
#8
|
|||
|
|||
Crosstab Row Sorting in Alphabetical Order
Did you try as I suggested by changing the sorting and grouping expression to:
=Val([Rank]) BTW: your example seemed to be sorted correctly. Why do you need to change it? -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have the following three items in the dialog box before the rank that are grouped with a header, the rank does not have a header It reads like: PrimaryID Ascending (Grouped with Header) Category Description Ascending (Grouped with a Header) Category Detail Ascending (Grouped with a Header) Rank Ascending (No Header) The Rank field shows to be left aligned. None of the tables have a look up field -- Alison "Duane Hookom" wrote: What exactly do you have in the sorting and grouping dialog? Is the Rank field left or right aligned in the datasheet view? Are there any lookup fields in your tables? -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: It didn't work, do I need to replace the control source with it, or just put it in the grouping and sort dialog box? -- Alison "Duane Hookom" wrote: Put it where "I have the rank (count) in the report under the grouping section" I assume this is the sorting and grouping dialog in report design. -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: Yes they are numbers and it starts at 1 example of what it looks like: Rank Column1 Column2 1 WED5700 White WGD6400 White 2 WED6400 White Where exactly would I put the =Val([Rank]) in the report? Thank you so much for your help..... -- Alison "Duane Hookom" wrote: It would help if you provided some values from the Rank field in the order you are seeing them in the report. If the Rank field seems like numbers but is left-aligned in datasheet view, it is being evaluated as text/string. You might be able to simply set the sorting and grouping expression to: =Val([Rank]) -- Duane Hookom Microsoft Access MVP "alison.justice" wrote: I have a report based off of a crosstab query that the data under the columns is text. I am trying to sort them in alphabetical order and keep them lined up. I have the rank (count) in the report under the grouping section to sort in ascending order but it sorts the text backwards, when I change it to decending it will sort the longest column in order but the smaller columns it puts at the bottom of the column instead of starting at the top. Following is the code for the Crosstab: SELECT Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6 FROM Table_Customer INNER JOIN Query_Customer_Catalog_Crosstab_Final ON (Table_Customer.NeighborhoodID = Query_Customer_Catalog_Crosstab_Final.neighborhood id) AND (Table_Customer.BuilderID = Query_Customer_Catalog_Crosstab_Final.builderid) GROUP BY Table_Customer.PrimaryID, Query_Customer_Catalog_Crosstab_Final.builderid, Query_Customer_Catalog_Crosstab_Final.neighborhood id, Query_Customer_Catalog_Crosstab_Final.categoryid, Query_Customer_Catalog_Crosstab_Final.categorydesc ription, Query_Customer_Catalog_Crosstab_Final.categorydeta ildescription, Query_Customer_Catalog_Crosstab_Final.rank, Query_Customer_Catalog_Crosstab_Final.S, Query_Customer_Catalog_Crosstab_Final.U2, Query_Customer_Catalog_Crosstab_Final.U3, Query_Customer_Catalog_Crosstab_Final.U4, Query_Customer_Catalog_Crosstab_Final.U5, Query_Customer_Catalog_Crosstab_Final.U6; I'm not an advanced user so you might have to step me through what I would need to do. Any ideas or suggestions that you could give is really appreciated. I am using Access 2007. -- Alison |
Thread Tools | |
Display Modes | |
|
|