Re: Combining the data from various fileds and add to a memo field in a table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PS (kasiong_at_hotmail.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 16:33:03 +0800

Hi Andy,

Yes, my purpose to doing so is actually for viewing and reporting purpose, i
need it also to export to excel spreasheet within single column as we need
to submit to our HQ using fixed format.
Appreciate if you could help me on how to write the query in order to
produce this result.

Thank.
PS

"Andy Williams" <captain747480@ntlworld.com> wrote in message
news:cpGSc.126$oP2.79@newsfe5-gui.ntli.net...
> My first thought would be why do you want to reproduce all the data in
> another table. That defeats the object of having a database in the first
> place.
>
> If the combined field is just for reporting or viewing purposes then you
> could use a query to produce the combined field and display it in a form
or
> report.
>
> If you want help on how to write the query let me know.
>
> HTH
>
> Andy W
>
>
> "PS" <kasiong@hotmail.com> wrote in message
> news:OurgbxCgEHA.704@TK2MSFTNGP09.phx.gbl...
> > Hi All,
> >
> > Please help for following scenario!
> >
> > I need to have a table cointaining fields:
> >
> > EventID
> > CaseID
> > EventDate
> > StartTime
> > StopTime
> > EventDescription
> >
> > I need to add a command to combine all the fileld above and automatic
add
> > and apend it to a memo field in another table to become a summary event
> > detail, for example:
> >
> > ***Start***
> > EventID : 1234
> > CaseID : A123
> > EventDate : 12/08/2004
> > StartTime : 12:15PM
> > StopTime : 13:25PM
> > EventDescription : Test for event logging 1
> > ***End***
> >
> > ***Start***
> > EventID : 2234
> > CaseID : A125
> > EventDate : 12/08/2004
> > StartTime : 18:15PM
> > StopTime : 19:25PM
> > EventDescription : Test for event logging 2
> > ***End***
> >
> > Thank!
> >
> > PS
> >
> >
> >
> >
>
>

Relevant Pages