rows in a report
in [Reports]
|
Prev: Assemby Report
Next: Testing with Access 2010
From: PJ on 10 Mar 2010 15:02 Thanks Karl. Would you explain the below code for me. I guess I am not getting it to work for me. This would be placed in a query in SQL view but no luck. Thank you for being your assistance!! "KARL DEWEY" wrote: > 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!!! > > > > >
From: KARL DEWEY on 11 Mar 2010 00:32
You have to use your table and field names. [MaxOfYourRows] is the text box you said you had that indicated the maximum number of records any one had. -- Build a little, test a little. "PJ" wrote: > Thanks Karl. Would you explain the below code for me. I guess I am not > getting it to work for me. This would be placed in a query in SQL view but > no luck. > > Thank you for being your assistance!! > > "KARL DEWEY" wrote: > > > 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!!! > > > > > > |