Query Expert

[wschian]

Hi, Any expert here can teach me how to make a query2 from Table(query 1)
I want to print the data in the Table (Or Query1), Two data per row. Numbers of print is equal to the number of items. So I need a query like Query2 to print


print results like below

Apple			Apple
$ 200.00			$ 200.00
Apple			Car
$ 200.00			$ 11.00
Car			House
$ 11.00			$ 21.00
House			House
$ 21.00			$ 21.00
House			House
$ 21.00			$ 21.00

[orange]

Please tell us in plain, simple English what you are trying to accomplish. No database jargon.
What does this data represent?

[ranman256]

1. 1. You should not even have query2.

2. You can convert query2 by making other queries:
Q1: count items in Cols 2,3
Q2: count items in cols 4,5
Q3: make union query of Q1 & 2 to get the final count you want.

[JoeM]

removed, misinterpretted question

[wschian]

Please tell us in plain, simple English what you are trying to accomplish. No database jargon.
What does this data represent?

Thanks for your reply, :-) I'm no good in english.
I want to print the data in the Table (Or Query1), Two data per row. Numbers of print is equal to the number of items. So I need a query like Query2 to print.

[wschian]

thanks ranman, you are right. I should not have Query2 . I just want to let everyone know what the query I want is. :-)

[wschian]

removed, misinterpretted question

JoeM
Thanks for you reply, I am not malicious to make misinterpretted question. My English is not well expressed. I hope you can understand.

[orange]

wschian,

Whatever your native language, write a description of what you want to do (as much detail as required) in your language.
Then go to google translate and translate your message into English.
Then post the English translation.
Good luck.

[JoeM]

Thanks for you reply, I am not malicious to make misinterpretted question. My English is not well expressed. I hope you can understand.

No, nothing on your end. I posted a reply, then realized that I read your question wrong, so my reply would not work for you, so I deleted it.