Sorry, I did a reply, but I want to post for help!!
Dear All,
Last year, with the great help from vbaInet, I put the concat function into my queries, it worked fine with a few entries, but run like forever for > 3000 entries. Now I am in deep trouble. I have to force to erase the function from all the queries. Let's start over with your help!
I have a Detail Training Table and 2 supplementary tables (consecutive/non-consecutive days), in which I created an entry form for user. As a result, there will be all connected to a DetailID. For example:
The big pool:
ID Staff Course CourseDate TotalDays Cost
5 John ACCESS 1/2/2011 to 3/2/2011 4 200.00
5 John ACCESS 5/2/2011 4 200.00
5 John ACCESS 7/2/2011 4 200.00
With some queries help, I calculated total number of days to 4, and the cost is only 200.00 for the whole deal.
Before I used concat function in query, it gives me this:
The elegant pool:
ID Staff Course CourseDate TotalDays Cost
5 John ACCESS 1/2/2011 to 3/2/2011, 4 200.00
5/2/2011, 7/2/2011
Now I have a big table like the “Big Pool”, with >6000 records, and wanted to put it in a report and display it out like the “Elegant Pool”!
Can I use "Concat" function in Report Textbox, but how to avoid multiple display identical results??????
Hope I am not asking for too much!
Thank you in advance
Rabbit
Dear All,
Last year, with the great help from vbaInet, I put the concat function into my queries, it worked fine with a few entries, but run like forever for > 3000 entries. Now I am in deep trouble. I have to force to erase the function from all the queries. Let's start over with your help!
I have a Detail Training Table and 2 supplementary tables (consecutive/non-consecutive days), in which I created an entry form for user. As a result, there will be all connected to a DetailID. For example:
The big pool:
ID Staff Course CourseDate TotalDays Cost
5 John ACCESS 1/2/2011 to 3/2/2011 4 200.00
5 John ACCESS 5/2/2011 4 200.00
5 John ACCESS 7/2/2011 4 200.00
With some queries help, I calculated total number of days to 4, and the cost is only 200.00 for the whole deal.
Before I used concat function in query, it gives me this:
The elegant pool:
ID Staff Course CourseDate TotalDays Cost
5 John ACCESS 1/2/2011 to 3/2/2011, 4 200.00
5/2/2011, 7/2/2011
Now I have a big table like the “Big Pool”, with >6000 records, and wanted to put it in a report and display it out like the “Elegant Pool”!
Can I use "Concat" function in Report Textbox, but how to avoid multiple display identical results??????
Hope I am not asking for too much!
Thank you in advance
Rabbit
