rows in a report

[PJ]

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!!!

 

[Duane Hookom]

Does the "number" come from the report's record source? Is there only one
record and one "number"?

 

[PJ]

It comes from the report's record source and it is the same number on all
records.

 

[Duane Hookom]

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.

 

[PJ]

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]

What does a blank look like?
Is each customer on its own page?

 

[PJ]

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]

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?

 

[PJ]

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.

 

[KARL DEWEY]

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;

 

[PJ]

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!!

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.

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.

 

[KARL DEWEY]

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.

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!!

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.

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.

:

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


:

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!!!

:

What does a blank look like?
Is each customer on its own page?

--
Duane Hookom
MS Access MVP

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.

:

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


:

It comes from the report's record source and it is the same number on
all
records.

:

Does the "number" come from the report's record source? Is there only
one
record and one "number"?
--
Duane Hookom
Microsoft Access MVP


:

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!!!