If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Access and using the Average function in a report
Help pleaes.
i am trying to do a project where i need to make a report which is sweet but where i am struggling is where they also want to find out an average on the amount of days someone has stayed but only being new to the calculations using MS Access i have no idea how they work in there only in Excel please help me if you can -- Life is but a Dream... Reality is the Real Nightmare |
#2
|
|||
|
|||
MS Access and using the Average function in a report
In any report or group (not page) header or footer, you can use a text box
with a control source like: =Avg(DateDiff("d",[StartDate], [EndDate]) If you can't figure this out, then come back with enough information regarding your report record source and maybe some sample data and desired display. -- Duane Hookom Microsoft Access MVP "Marc Gander" wrote: Help pleaes. i am trying to do a project where i need to make a report which is sweet but where i am struggling is where they also want to find out an average on the amount of days someone has stayed but only being new to the calculations using MS Access i have no idea how they work in there only in Excel please help me if you can -- Life is but a Dream... Reality is the Real Nightmare |
Thread Tools | |
Display Modes | |
|
|