query output as a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following simple query in a sub form

SELECT sdetail1.[name id], sdetail1.[shift date], sdetail1.activity
FROM sdetail1
WHERE (((sdetail1.[name id])=[forms]![add activity]![name id]) AND
((sdetail1.[shift date])=[forms]![add activity]![shift date]));

This works but if patient id and date are = and i have more than 1 record I
would like a list like chess,checkers on 1 line instead of chess then a new
line also new record checkers. Any help would be geatly appreciated.

Thanks
Martin
 
martin said:
I have the following simple query in a sub form

SELECT sdetail1.[name id], sdetail1.[shift date], sdetail1.activity
FROM sdetail1
WHERE (((sdetail1.[name id])=[forms]![add activity]![name id]) AND
((sdetail1.[shift date])=[forms]![add activity]![shift date]));

This works but if patient id and date are = and i have more than 1 record I
would like a list like chess,checkers on 1 line instead of chess then a new
line also new record checkers. Any help would be geatly appreciated.
Click to expand...


Take a look at Duane's Concatenate Child Records function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
 
Back
Top