To Bring The Datas in different rows for the Same date together

[nizam]

Dear Friends
Kindly help me to solve regarding one query

I need to bring the datas in for different items for the "Same Date" as one result.

Eg:

Date	ID No 1	ID No 2
20-09-12	22	21
20-09-12	45	46

I need to return the result as,

Date	ID Nos
20-09-12	22,21,45,46

Like this

How to build the expression.

Please advise

[nizam]

Dear Friend
Plz advise me , how to bring 2 rows together in 1 expression in access qurey

[nizam]

Plz advise.. very urgent

[JoeM]

Can you provide more details?
An example would be helpful.

[nizam]

Date	W
26-Oct-11	HI-501,HI-222,HI-200,HI-503,HI-200,HI-503
26-Oct-11	HI-501,HI-222,HI-210,HI-504,HI-200,HI-503
27-Oct-11	HI-501,HI-222,HI-210,HI-209,HI-200,HI-503
27-Oct-11	HI-501,HI-222,HI-501,HI-222,HI-200,HI-503
27-Oct-11	HI-504,HI-222,HI-210,HI-209,HI-200,HI-503
29-Oct-11	HI-501,HI-222,HI-210,HI-209,HI-200,HI-503
29-Oct-11	HI-504,HI-222,HI-210,HI-209,HI-200,HI-503

Dear,
Please find the above table, made from a query.
In that query see the date, 26-Oct-11 and the Column W is having 2 different datas.
I need to bring the date only in one row and the datas for that 26-Oct-11, coming in 2 rows have to come in one row.

This datas are the details of a production for different dates.
For a same dat or date , there is different crews working in different areas for the same activity.
I need to join together the production datas , named as "W" to come in one row for a same day/date

please help

[JoeM]

I see that you had posted this question twice, and the Moderators merged them together.

The data structure you are talking about really isn't normalized, and I don't know if it can be done without VBA. If it were me, I would probably use DAO Recordsets to loop through the query, and write the results to a new table. That new table obviously won't be dynamic, but I can't think of any better way.

What is the reason for needing the data structured like this?

[nizam]

I need to submit the datas of procution for each crew for the same together with the number of manpower involved in this in the same date.

[nizam]

one related doubt..
is it possible to use
"are equal" function in query? if so how ?

[orange]

see http://allenbrowne.com/func-concat.html