query

[alxw3 via AccessMonster.com]

can't get this right. IN THIS SELF TUTORIAL I TRY TO REACH OUTPUT FROM TABLE1.


TABLE1:
DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 A2 A3 B1 B2
B3 B4

OUTPUT:
NAME ORDER LABEL CO C1 C2 C3 C4 C5 C6
DB 1 L1 G0 J0 N0 A0 A1 A2
A3
DB 2 L2 G1 J1 N1 B1 B2 B3
B4
DB 3 L3 G2 J2 N2
DB 4 L4 G3 J3 N3

 

[alxw3 via AccessMonster.com]

input and output are, actually;
TABLE1:
DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 B1 B2

OUTPUT:
NAME ORDER LABEL1 CO C1 C2 label2 C3 C4
DB 1 L1 G0 J0 N0 L5 A0
B1
DB 2 L2 G1 J1 N1 L6 A1
B2
DB 3 L3 G2 J2 N2
DB 4 L4 G3 J3 N3

 

[John W. Vinson]

can't get this right. IN THIS SELF TUTORIAL I TRY TO REACH OUTPUT FROM TABLE1.


TABLE1:
DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 A2 A3 B1 B2
B3 B4

OUTPUT:
NAME ORDER LABEL CO C1 C2 C3 C4 C5 C6
DB 1 L1 G0 J0 N0 A0 A1 A2
A3
DB 2 L2 G1 J1 N1 B1 B2 B3
B4
DB 3 L3 G2 J2 N2
DB 4 L4 G3 J3 N3

I'm sorry, but this makes no sense at all.

What is the structure of Table1? Are these fieldnames, or data in the fields,
or are they a bunch of records in a one-field table?

What's the logic? How does the "Name" field become DB? What's the meaning of
"order"?

What are the C0-C6 fields?

Please reread this message with your mind cleared of your previous knowledge
of the database and of the problem. There really isn't enough information
there for anyone to help, is there?

 

[alxw3 via AccessMonster.com]

yes. how about this?.
TABLE1:
DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 B1 B2
db1 5 4 7 8 1 3 6 4 8 9 10 11 5 4 3 8



OUTPUT:
NAME ORDER LABEL1 CO C1 C2 label2 C3 C4
db1 1 L1 5 1 8 L5 5 3

db1 2 L2 4 3 9 L6 4 8
db1 3 L3 7 6 10
db1 4 L4 8 4 11

can't get this right. IN THIS SELF TUTORIAL I TRY TO REACH OUTPUT FROM TABLE1.

[quoted text clipped - 10 lines]

DB 3 L3 G2 J2 N2
DB 4 L4 G3 J3 N3

I'm sorry, but this makes no sense at all.

What is the structure of Table1? Are these fieldnames, or data in the fields,
or are they a bunch of records in a one-field table?

What's the logic? How does the "Name" field become DB? What's the meaning of
"order"?

What are the C0-C6 fields?

Please reread this message with your mind cleared of your previous knowledge
of the database and of the problem. There really isn't enough information
there for anyone to help, is there?

 

[John W. Vinson]

yes. how about this?.
TABLE1:
DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 B1 B2
db1 5 4 7 8 1 3 6 4 8 9 10 11 5 4 3 8



OUTPUT:
NAME ORDER LABEL1 CO C1 C2 label2 C3 C4
db1 1 L1 5 1 8 L5 5 3

db1 2 L2 4 3 9 L6 4 8
db1 3 L3 7 6 10
db1 4 L4 8 4 11

I'm sorry, but THIS DOES NOT HELP AT ALL.

It appears that you have a table with a fields named DB, G0, G1, etc. with
numbers in these fields.

Somehow you want to generate an Order field. You don't say how.

Somehow you want to generate two Label fields. You don't say how.

Somehow you want to generate four C# fields. You don't say how.

I'd love to be able to help, but I can only help if you explain the problem
and what it is that you are trying to accomplish. Please feel free to use
words, not just copy and paste of meaningless sets of numbers.

 

[alxw3 via AccessMonster.com]

Yes. It is a weird one. Something opposite to cross tab method maybe. myself
i do not know how. The table is weird.

yes. how about this?.
TABLE1:

[quoted text clipped - 8 lines]

db1 3 L3 7 6 10
db1 4 L4 8 4 11

I'm sorry, but THIS DOES NOT HELP AT ALL.

It appears that you have a table with a fields named DB, G0, G1, etc. with
numbers in these fields.

Somehow you want to generate an Order field. You don't say how.

Somehow you want to generate two Label fields. You don't say how.

Somehow you want to generate four C# fields. You don't say how.

I'd love to be able to help, but I can only help if you explain the problem
and what it is that you are trying to accomplish. Please feel free to use
words, not just copy and paste of meaningless sets of numbers.

 

[John W. Vinson]

Yes. It is a weird one. Something opposite to cross tab method maybe. myself
i do not know how. The table is weird.

yes. how about this?.
TABLE1:

[quoted text clipped - 8 lines]

db1 3 L3 7 6 10
db1 4 L4 8 4 11

I'm sorry, but THIS DOES NOT HELP AT ALL.

It appears that you have a table with a fields named DB, G0, G1, etc. with
numbers in these fields.

Somehow you want to generate an Order field. You don't say how.

Somehow you want to generate two Label fields. You don't say how.

Somehow you want to generate four C# fields. You don't say how.

I'd love to be able to help, but I can only help if you explain the problem
and what it is that you are trying to accomplish. Please feel free to use
words, not just copy and paste of meaningless sets of numbers.

<shrug>

I'd be glad to try to help, but I cannot do so given your complete lack of
explanation of what you want.

I hope someone with better telepathy will be able to assist you. I can't.