romeiovasu
asked on
database question
database question.
i want to calculate a trend values in a field
i have field which shows total count of numbers. from that i want to show the trend in a separate field. by present date.
how can i do that
i want the query for both access and mssql
can some body help me in this.
i want to calculate a trend values in a field
i have field which shows total count of numbers. from that i want to show the trend in a separate field. by present date.
how can i do that
i want the query for both access and mssql
can some body help me in this.
Please provide some data
ASKER
for example
i have count of 100 numbers and i want to forcast for this month
what i am doing in or access manually is
trend = (100/day of the month)*no of days in a month
like
trend = (100/6)*30 = 500
i have count of 100 numbers and i want to forcast for this month
what i am doing in or access manually is
trend = (100/day of the month)*no of days in a month
like
trend = (100/6)*30 = 500
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can you tell me how to use in a sql query
i got it for access i used in a simple way
DateDiff("d",Date()-(Day(D ate()- 1)), DateSerial(Year(Date()),(M onth(Date( ))+1),1))
now i am using sql 2005 i want to get in sql query
i got it for access i used in a simple way
DateDiff("d",Date()-(Day(D
now i am using sql 2005 i want to get in sql query
ASKER
ok got it thank you