There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
function should be able to "put multiple clients into one" expression.
--
Duane Hookom
MS Access MVP
<nherem[ at ]slingshot.co.nz> wrote in message
news:1157931169.595085.94910[ at ]d34g2000cwd.googlegroups.com...
[Quoted Text] > Thanks, > > However how would you put multiple clients into one time slot? in our > organisation we can see a number of different clients at once. > > Duane Hookom wrote: >> Check the calendar reports at http://www.access.hookom.net/Samples.htm.>> There are a couple examples that might work. >> >> -- >> Duane Hookom >> MS Access MVP >> >> <nherem[ at ]slingshot.co.nz> wrote in message >> news:1157895409.020853.277990[ at ]d34g2000cwd.googlegroups.com... >> > Hi, I am trying to create a time table report for an organisation I >> > work with. >> > >> > >> > I have tried using a crosstab but this doesn't work. >> > >> > This is what I want the report to look like: >> > Monday Tuesday Wednesday Thursday Friday >> > 9.00 joe joe >> > adam dave >> > sarah >> > >> > 10.00 george >> > john >> > paul >> > 11.00 >> > >> > >> > 12.00 >> > >> > with a crosstab I'm finding that acess returns only the maximum or >> > minimum fields, so eg. for monday at 9.00 only joe is returned if the >> > maximum expression is set. >> > >> > can someone please help as this is driving me crazy. >> > >> > thanks nige >> > >
|