Do you mean two tables for each fund? Thank you Valter
--- In [email protected], "Dan Powderhill" <[EMAIL PROTECTED]> wrote: > > Normalise it into two tables:- > > tblFunds > ------------ > ID > FundName > > tblFundValues > -------------------- > ID > FundID > Value > Date > > Then you can have a history of values by date for every fund, and using > basic SQL will be able to bring back the current and current-but-one > values using the TOP keyword (SELECT TOP 2 [Value] FROM [tblFundValues] > ORDER BY [Date] DESC) etc. > > Dan > > ________________________________ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Valter > Sent: 25 October 2005 12:40 > To: [email protected] > Subject: [AspClassicAnyQuestionIsOk] Quotation table > > > For my personal project I am trying to design a table in which there > will be a list of funds, their last month value and their previous > month value. I do know how to make it with only one fund but with many > of them I've found some problems. Can anybody help me? > I draft a sample of the table how it should look: > Fund1 last_value prev_value > Fund2 last_value prev_value > ... > ... > I can have a table for each fund with all values order by date > > Thank you > > > > > > > SPONSORED LINKS > Basic programming language > <http://groups.yahoo.com/gads? t=ms&k=Basic+programming+language&w1=Basic > +programming+language&w2=Computer+programming+languages&w3=Programming +l > anguages&w4=Java+programming+language&c=4&s=126&.sig=bnac3LCZpttb3c9Fv bV > U-A> Computer programming languages > <http://groups.yahoo.com/gads? t=ms&k=Computer+programming+languages&w1=B > asic+programming+language&w2=Computer+programming+languages&w3=Program mi > ng+languages&w4=Java+programming+language&c=4&s=126&.sig=1Czd2hKCO9_u4 KV > ZQperFQ> Programming languages > <http://groups.yahoo.com/gads? t=ms&k=Programming+languages&w1=Basic+prog > ramming+language&w2=Computer+programming+languages&w3=Programming+lang ua > ges&w4=Java+programming+language&c=4&s=126&.sig=TyHGCjod4YOKITrSq1xccQ > > > Java programming language > <http://groups.yahoo.com/gads? t=ms&k=Java+programming+language&w1=Basic+ > programming+language&w2=Computer+programming+languages&w3=Programming+ la > nguages&w4=Java+programming+language&c=4&s=126&.sig=PZAexF9LyXpKb3HDJS lB > 1g> > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AspClassicAnyQuestionIsOk > <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Un > subscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > ________________________________ > > > > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
