rows in a report
in [Reports]
|
Prev: Assemby Report
Next: Testing with Access 2010
From: Duane Hookom on 9 Mar 2010 23:44 What does a blank look like? Is each customer on its own page? -- Duane Hookom MS Access MVP "PJ" <PJ(a)discussions.microsoft.com> wrote in message news:EB0699AE-A91A-4A34-B08B-D27A3819F1A7(a)microsoft.com... > If I have a customer with only 2 rows of data and another customer with 6 > rows of data I would want the customer with only 2 rows to show 6 rows of > instead of 2. I understand that 4 of the rows in the report would be > blank. > One of my queries has a "Max" for the total so I can find out how many > records each cusomer has and that is how many rows I want printed for each > customer. I hope this is making sense. > > Thank you. > > "Duane Hookom" wrote: > >> What do you mean by a "row" and where do you want these? Do you mean >> solid >> horizontal lines at the end of the report or what? >> >> Please provide all the significant specifications so someone can provide >> some assistance. >> >> -- >> Duane Hookom >> Microsoft Access MVP >> >> >> "PJ" wrote: >> >> > It comes from the report's record source and it is the same number on >> > all >> > records. >> > >> > "Duane Hookom" wrote: >> > >> > > Does the "number" come from the report's record source? Is there only >> > > one >> > > record and one "number"? >> > > -- >> > > Duane Hookom >> > > Microsoft Access MVP >> > > >> > > >> > > "PJ" wrote: >> > > >> > > > I have a text box with a number in it. How would I make that many >> > > > rows in a >> > > > report based off the number in the text box? >> > > > >> > > > Thanks in advance!!!
From: PJ on 10 Mar 2010 09:17 This is what I have. A main report that has columns down and accross. I had to then add a few subreports. When the report prints the subreport does not always line up with other customers because there may be more data for some customers and not others. I want the report to line up so I did a count in the query with the max count showing. Now I want that max count to show that many rows in the subreport. Or is there a better way to do this???? Thanks in advance!!! "Duane Hookom" wrote: > What does a blank look like? > Is each customer on its own page? > > -- > Duane Hookom > MS Access MVP > > "PJ" <PJ(a)discussions.microsoft.com> wrote in message > news:EB0699AE-A91A-4A34-B08B-D27A3819F1A7(a)microsoft.com... > > If I have a customer with only 2 rows of data and another customer with 6 > > rows of data I would want the customer with only 2 rows to show 6 rows of > > instead of 2. I understand that 4 of the rows in the report would be > > blank. > > One of my queries has a "Max" for the total so I can find out how many > > records each cusomer has and that is how many rows I want printed for each > > customer. I hope this is making sense. > > > > Thank you. > > > > "Duane Hookom" wrote: > > > >> What do you mean by a "row" and where do you want these? Do you mean > >> solid > >> horizontal lines at the end of the report or what? > >> > >> Please provide all the significant specifications so someone can provide > >> some assistance. > >> > >> -- > >> Duane Hookom > >> Microsoft Access MVP > >> > >> > >> "PJ" wrote: > >> > >> > It comes from the report's record source and it is the same number on > >> > all > >> > records. > >> > > >> > "Duane Hookom" wrote: > >> > > >> > > Does the "number" come from the report's record source? Is there only > >> > > one > >> > > record and one "number"? > >> > > -- > >> > > Duane Hookom > >> > > Microsoft Access MVP > >> > > > >> > > > >> > > "PJ" wrote: > >> > > > >> > > > I have a text box with a number in it. How would I make that many > >> > > > rows in a > >> > > > report based off the number in the text box? > >> > > > > >> > > > Thanks in advance!!! >
From: Duane Hookom on 10 Mar 2010 10:44 Are the subreports new or have they been in your report since your first post? Also the multiple columns? If I understand your new question, what happens if your columns display across then down? -- Duane Hookom Microsoft Access MVP "PJ" wrote: > This is what I have. A main report that has columns down and accross. I had > to then add a few subreports. When the report prints the subreport does not > always line up with other customers because there may be more data for some > customers and not others. I want the report to line up so I did a count in > the query with the max count showing. Now I want that max count to show that > many rows in the subreport. Or is there a better way to do this???? > > > Thanks in advance!!! > > "Duane Hookom" wrote: > > > What does a blank look like? > > Is each customer on its own page? > > > > -- > > Duane Hookom > > MS Access MVP > > > > "PJ" <PJ(a)discussions.microsoft.com> wrote in message > > news:EB0699AE-A91A-4A34-B08B-D27A3819F1A7(a)microsoft.com... > > > If I have a customer with only 2 rows of data and another customer with 6 > > > rows of data I would want the customer with only 2 rows to show 6 rows of > > > instead of 2. I understand that 4 of the rows in the report would be > > > blank. > > > One of my queries has a "Max" for the total so I can find out how many > > > records each cusomer has and that is how many rows I want printed for each > > > customer. I hope this is making sense. > > > > > > Thank you. > > > > > > "Duane Hookom" wrote: > > > > > >> What do you mean by a "row" and where do you want these? Do you mean > > >> solid > > >> horizontal lines at the end of the report or what? > > >> > > >> Please provide all the significant specifications so someone can provide > > >> some assistance. > > >> > > >> -- > > >> Duane Hookom > > >> Microsoft Access MVP > > >> > > >> > > >> "PJ" wrote: > > >> > > >> > It comes from the report's record source and it is the same number on > > >> > all > > >> > records. > > >> > > > >> > "Duane Hookom" wrote: > > >> > > > >> > > Does the "number" come from the report's record source? Is there only > > >> > > one > > >> > > record and one "number"? > > >> > > -- > > >> > > Duane Hookom > > >> > > Microsoft Access MVP > > >> > > > > >> > > > > >> > > "PJ" wrote: > > >> > > > > >> > > > I have a text box with a number in it. How would I make that many > > >> > > > rows in a > > >> > > > report based off the number in the text box? > > >> > > > > > >> > > > Thanks in advance!!! > >
From: PJ on 10 Mar 2010 11:47 No, The subreports are not new. I want columns for the data so the data is side by side so I need to go down then across. "Duane Hookom" wrote: > Are the subreports new or have they been in your report since your first > post? Also the multiple columns? > > If I understand your new question, what happens if your columns display > across then down? > > -- > Duane Hookom > Microsoft Access MVP > > > "PJ" wrote: > > > This is what I have. A main report that has columns down and accross. I had > > to then add a few subreports. When the report prints the subreport does not > > always line up with other customers because there may be more data for some > > customers and not others. I want the report to line up so I did a count in > > the query with the max count showing. Now I want that max count to show that > > many rows in the subreport. Or is there a better way to do this???? > > > > > > Thanks in advance!!! > > > > "Duane Hookom" wrote: > > > > > What does a blank look like? > > > Is each customer on its own page? > > > > > > -- > > > Duane Hookom > > > MS Access MVP > > > > > > "PJ" <PJ(a)discussions.microsoft.com> wrote in message > > > news:EB0699AE-A91A-4A34-B08B-D27A3819F1A7(a)microsoft.com... > > > > If I have a customer with only 2 rows of data and another customer with 6 > > > > rows of data I would want the customer with only 2 rows to show 6 rows of > > > > instead of 2. I understand that 4 of the rows in the report would be > > > > blank. > > > > One of my queries has a "Max" for the total so I can find out how many > > > > records each cusomer has and that is how many rows I want printed for each > > > > customer. I hope this is making sense. > > > > > > > > Thank you. > > > > > > > > "Duane Hookom" wrote: > > > > > > > >> What do you mean by a "row" and where do you want these? Do you mean > > > >> solid > > > >> horizontal lines at the end of the report or what? > > > >> > > > >> Please provide all the significant specifications so someone can provide > > > >> some assistance. > > > >> > > > >> -- > > > >> Duane Hookom > > > >> Microsoft Access MVP > > > >> > > > >> > > > >> "PJ" wrote: > > > >> > > > >> > It comes from the report's record source and it is the same number on > > > >> > all > > > >> > records. > > > >> > > > > >> > "Duane Hookom" wrote: > > > >> > > > > >> > > Does the "number" come from the report's record source? Is there only > > > >> > > one > > > >> > > record and one "number"? > > > >> > > -- > > > >> > > Duane Hookom > > > >> > > Microsoft Access MVP > > > >> > > > > > >> > > > > > >> > > "PJ" wrote: > > > >> > > > > > >> > > > I have a text box with a number in it. How would I make that many > > > >> > > > rows in a > > > >> > > > report based off the number in the text box? > > > >> > > > > > > >> > > > Thanks in advance!!! > > >
From: KARL DEWEY on 10 Mar 2010 12:54
Auto is an autonuber field or any field with unique data. This query will give you the required number of rows -- SELECT Q.Style, Q.Sales, (SELECT Count(*) FROM Aaron AS Q1 WHERE Q.Auto >= Q1.Auto) AS Sequence FROM Aaron AS Q WHERE ((((SELECT Count(*) FROM Aaron AS Q1 WHERE Q.Auto >= Q1.Auto))<=[MaxOfYourRows])) ORDER BY IIf([style] Is Null,1,0), Q.Style, Q.Sales; -- Build a little, test a little. "PJ" wrote: > No, The subreports are not new. I want columns for the data so the data is > side by side so I need to go down then across. > > "Duane Hookom" wrote: > > > Are the subreports new or have they been in your report since your first > > post? Also the multiple columns? > > > > If I understand your new question, what happens if your columns display > > across then down? > > > > -- > > Duane Hookom > > Microsoft Access MVP > > > > > > "PJ" wrote: > > > > > This is what I have. A main report that has columns down and accross. I had > > > to then add a few subreports. When the report prints the subreport does not > > > always line up with other customers because there may be more data for some > > > customers and not others. I want the report to line up so I did a count in > > > the query with the max count showing. Now I want that max count to show that > > > many rows in the subreport. Or is there a better way to do this???? > > > > > > > > > Thanks in advance!!! > > > > > > "Duane Hookom" wrote: > > > > > > > What does a blank look like? > > > > Is each customer on its own page? > > > > > > > > -- > > > > Duane Hookom > > > > MS Access MVP > > > > > > > > "PJ" <PJ(a)discussions.microsoft.com> wrote in message > > > > news:EB0699AE-A91A-4A34-B08B-D27A3819F1A7(a)microsoft.com... > > > > > If I have a customer with only 2 rows of data and another customer with 6 > > > > > rows of data I would want the customer with only 2 rows to show 6 rows of > > > > > instead of 2. I understand that 4 of the rows in the report would be > > > > > blank. > > > > > One of my queries has a "Max" for the total so I can find out how many > > > > > records each cusomer has and that is how many rows I want printed for each > > > > > customer. I hope this is making sense. > > > > > > > > > > Thank you. > > > > > > > > > > "Duane Hookom" wrote: > > > > > > > > > >> What do you mean by a "row" and where do you want these? Do you mean > > > > >> solid > > > > >> horizontal lines at the end of the report or what? > > > > >> > > > > >> Please provide all the significant specifications so someone can provide > > > > >> some assistance. > > > > >> > > > > >> -- > > > > >> Duane Hookom > > > > >> Microsoft Access MVP > > > > >> > > > > >> > > > > >> "PJ" wrote: > > > > >> > > > > >> > It comes from the report's record source and it is the same number on > > > > >> > all > > > > >> > records. > > > > >> > > > > > >> > "Duane Hookom" wrote: > > > > >> > > > > > >> > > Does the "number" come from the report's record source? Is there only > > > > >> > > one > > > > >> > > record and one "number"? > > > > >> > > -- > > > > >> > > Duane Hookom > > > > >> > > Microsoft Access MVP > > > > >> > > > > > > >> > > > > > > >> > > "PJ" wrote: > > > > >> > > > > > > >> > > > I have a text box with a number in it. How would I make that many > > > > >> > > > rows in a > > > > >> > > > report based off the number in the text box? > > > > >> > > > > > > > >> > > > Thanks in advance!!! > > > > |