Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating a single record from multiple records
Hi HarleyQuinn, That worked perfectly for me thanks! I think i was overcomplicating things slightly. Originally when i looked at the FAQ i was attempting to amend the code in the module. I didnt actually realise it could work without making any changes. Looking at the SQL you provided its...- rachleck
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Creating a single record from multiple records
Hi HarleyQuinn Thanks for your help. I think that is actually one of the documents i looked at before posting. I couldn't quite work out what i needed to tweak to get it to work for me. One problem being that im not very familiar with VBA, my background really lies in crystal reporting, oracle...- rachleck
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Creating a single record from multiple records
Hi Darrylle Thanks for your reply, I need to do it purely for reporting really. The string of outcome's would be only ever get to around 35 maximum, so i wouldnt end up with huge strings. The date isnt that important really other than to order the string so id like the first outcome to be the...- rachleck
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Creating a single record from multiple records
Hi, Wondered if anyone could help me, i have some data in the following format; Team_ID Date Outcome 1 01/09/09 1 1 02/09/09 2 1 03/09/09 X 2 01/09/09 1 I would like to have a single line per team_id like the...- rachleck
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
