Recent content by Rabbit

Good lord, you have solved all my worries! All I have to do is add another items of Training course Title and Organizations. Thanks so much! You guys are God! Rabbit

Dear John, At the beginning, I thought about putting all the Trainings in one table, just do not know how to differentiate their types. I am not familiar (new to access), with the "type indicator field". I sounds wonderful and better already. Try to explore some information on this field!

Dear All, In our department, we have different kinds of trainings: TU (Training Unit), Overseas, InHouse (for local in our department), External (local but not in our department) Each will have it's own source tables: tblTU, tblOverseas, tblInHouse, tblExternal I want to create a Entry...

Spelling of my function: First I used ConcateRelated, then I add to the report ConcatedRelated!!!!! Many years ago, when I was in colleage, I took computer science! It took me overnight to debug a program with a mistake of "0" and "O" I changed my major afterward! Anyway thank you so much...

Thank you, finially I put this to work! Thank you so much for all the helps! Rabbit

No, it prompts me with "Enter Parameter Value" ConcateRelatedvba (the function name), besides, I spot a [Datefield] in your code, not quite match any fields in my query.

Ok, let me charge my laptop first and I'll try it.

Sorry, not concatenate staff name with the start/end day. through a form (contains Staff name text box, Start /End day text boxes), apply to a query as the criteria for 1) Staff Name 2) Lining. Then add the Concatenate function to the report..... or form module.....? By the way, back to the only...

You just got me going are you! OK ! Just wonder if I create another form which I will add a staff's name on + Start/End day, all I have to do is to change the SQL within? rabbit

Yes, I did put the code in a Module, and run it as a Function! Does it make any difference within a Form's module? rabbit

I understand the recordset does not like parameterised queries! after I put your suggestion into the Function, it gives me : invalid ME. I've been thinking over the whole situation for the past few days. I changed the report form a bit, leaving all the fields into the detail section. Do not...

Dear vbaInet, I am kind of loss and having a headache on this! Hope I did not give you too much troubles! on my qryNextGeneration4New: a field called: Lining (align records according to the first day of course); I added: "Between [Forms]![frmCountDayRange]![StartDate] And...

Further from above: I found out that the original report: I used a form to let the user select the start date and end date (criteria no. 1 is set to the qryNextGeneration3New), then when I use the ConcatRelated function on the row source for the report text box (2nd Criteria is set in along), as...

Problem: On the report, I created a DetailId group by and set up header, moved all the fields to that section, leaving the detail information section blank. then I add the followin to the original CourseDate Row Source. =ConcatRelated("CourseDate","qryNextGeneration3New","DetailID=" &...

Thanks, nice to hear from you again! I will try that and keep up posted! rabbit