Display the character in report (1 Viewer)

[libin04]

Hi Team,


please help me with this DB .

I would display the name in the report, which should display until the text box value fail. I mean if i give 5 in the count textbox field then the name should display five times in the report. i am attaching DB can you please have a look and revert it.

 

[Gasman]

I cannot even open the form in any view?, so I have no idea what you have done.

I would probably put the 5 records into a temp table and use that as the report source?

 

[libin04]

I cannot even open the form in any view?, so I have no idea what you have done.
View attachment 103735
I would probably put the 5 records into a temp table and use that as the report source?

It is opening for me Gasman. can you check one more time

 

[libin04]

I cannot even open the form in any view?, so I have no idea what you have done.
View attachment 103735

I cannot even open the form in any view?, so I have no idea what you have done.
View attachment 103735
I would probably put the 5 records into a temp table and use that as the report source?

intention to display not to record in the table
I would probably put the 5 records into a temp table and use that as the re

 

[Gasman]

It is opening for me Gasman. can you check one more time

Nope still the same.
I would put the number of records you need into a temp table and use that as the source?
A simple loop with an Append query sql code

 

[Gasman]

If you do not want to create a temp table, then you could create a Repeat table that will hold as many records as you wish to repeat.
Then create a cartesian join between that table and yours.

Use that query as the source of the report. That is what I would probably do, now that I have realised this other method.

I have hardcoded a number here, you would use what is on your form.

SELECT Table1.Field1, tblRepeat.RepeatNum
FROM Table1, tblRepeat
WHERE (((tblRepeat.RepeatNum)<=5));

You do not have to include the repeat number.

 

[KitaYama]

Nope still the same.

The form opens here. It's a simple form with a textbox and a combo.