query output as a list

M

martin

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
 
M

Marshall Barton

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
 
Top