query how to

[Piotr]

Hi I need to perform following query

Richard 3
Damian 4

I need to get result

Richard
Richard
Richard
Damian
Damian
Damian
Damian

regards
Peter

[Rick Brandt]

"Piotr" <ho***@wp.pl> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

Hi I need to perform following query

Richard 3
Damian 4

I need to get result

Richard
Richard
Richard
Damian
Damian
Damian
Damian

Not sure how a query could do that. Pretty easy in a Report though. Would that
suit your purpose?

In a report you could dim an integer variable (cntr) at the top of the report
module and then have code like this in the format event of the detail section...

If cntr < (Me!NumField - 1) Then
Me.MoveLayout = True
Me.PrintSection = True
Me.NextRecord = False
cntr = cntr + 1
Else
cntr = 0
End If

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Mike Preston]

On 16 Dec 2005 00:56:37 -0800, "Piotr" <ho***@wp.pl> wrote:

Hi I need to perform following query

Richard 3
Damian 4
Is the above two separate fields or it is one field where you have
both a name and a number in it?
I need to get result

Richard
Richard
Richard
Damian
Damian
Damian
Damian

Can you explain the context?

mike

[Piotr]

Two separate fields string and number.

[Mike Preston]

On 18 Dec 2005 23:26:46 -0800, "Piotr" <ho***@wp.pl> wrote:

Two separate fields string and number.

OK, exactly "where" do you need to get this result? A recordset? A
report? A table? A listbox? A combobox? Curious people want to know!

mike

[Piotr]

query to be able to use it in excel

[Mike Preston]

On 19 Dec 2005 04:51:44 -0800, "Piotr" <ho***@wp.pl> wrote:

query to be able to use it in excel

You'll have to set up a form, then a command button and finally some
vba to loop the recordset and output a new recordset/table.

mike