Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Integrate Data from multiple fields

Author  Topic 

Techsavy
Starting Member

4 Posts

Posted - 2008-05-14 : 00:39:05
Hi,

I have a table with five columns Date, Outfall1flow,Outfall2flow, Outfall3flow, outfall4flow

now I would like to have just three columns Date, OutfallFlow and OutfallID.

I would like to have flow only in one column identified by its id like 1,2,3,4..


How can I do this?

Thanks,
   

- Advertisement -