Select Column in Sequence

**ponderena** · Jul 25 '07, 11:39 AM

Select Column in Sequence

I have a situation where a person can have more then one item ordered. I need to layout the information as follows:

The first column, Person has:
1
1
2
3
3
3

The second column, Items Ordered has:

1 of 2
2 of 2
1 of 1
1 of 3
2 of 3
3 of 3

The third column, Item Description has:

Item1
Item2
Item1
Item3
Item1
Item2

.

I need to keep count of the the number of orders a person has and the tricky part for me is the ' num of <total number of orders>' column.

The information is in the same table and the Items Ordered is in relationship to the Person and not the Item Description.

If anyone could help me it would be appreciated

ponderena

**debasisdas** · Jul 25 '07, 11:44 AM

Can you please specify what exactly you want to achieve .

post with all your table structures and relations there off.

**ponderena** · Jul 25 '07, 11:46 AM

Could you please look at the post above Select Sequence it may be clearer of what I am trying to achieve.

ponderena

**ponderena** · Jul 25 '07, 11:47 AM

The name of the post is 'Select Column In Sequence'.

ponderena

**debasisdas** · Jul 25 '07, 11:48 AM

Kindly do not double post your questions .

Patiently wait for experts to answer your question.

**debasisdas** · Jul 25 '07, 11:50 AM

Post your questions clearly and specify what exactly you want to achieve .

post with all your table structures and relations there off.

**ponderena** · Jul 25 '07, 11:51 AM

The first post was not readable. So I posted another. I know now that I should have replied to the first with a revised version of my question.

ponderena

**debasisdas** · Jul 25 '07, 11:56 AM

Both the threads are merged for convenience

MODERATOR.

Select Column in Sequence

Select Column in Sequence

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment