Stayer
asked on
Display count of days in report (Access2007)
Hi experts,
I have a form where I input two dates and click a command button that opens up a report. By inputting start and end date in the form, records by that date in the corresponding table is displayed in the report by a query. This works fine. I have put a count in the report that totals the number of records that is displayed. However, in the same report I need to divide the number of records by the number of days I have inputted in the form, and display the result in percentage.
Can anyone suggest me how I can solve this?
Best regards,
Stayer
I have a form where I input two dates and click a command button that opens up a report. By inputting start and end date in the form, records by that date in the corresponding table is displayed in the report by a query. This works fine. I have put a count in the report that totals the number of records that is displayed. However, in the same report I need to divide the number of records by the number of days I have inputted in the form, and display the result in percentage.
Can anyone suggest me how I can solve this?
Best regards,
Stayer
ASKER
This works very good!
However, I need to learn how to input the mathematical expressions myself. Is there any guidelines anywhere as to using mathemaitcal expressions in reports or anywhere in the design view toolbar where there is a math - wizard etc.
Best regards,
Stayer
However, I need to learn how to input the mathematical expressions myself. Is there any guidelines anywhere as to using mathemaitcal expressions in reports or anywhere in the design view toolbar where there is a math - wizard etc.
Best regards,
Stayer
ASKER
Hi again,
Also I see in the provided sample that I manually have to input the number of days (sorry for being unclear on this). I need it to automatically calculate the number of days between the start and end - date (do not have to display this).
rgds,
Stayer
Also I see in the provided sample that I manually have to input the number of days (sorry for being unclear on this). I need it to automatically calculate the number of days between the start and end - date (do not have to display this).
rgds,
Stayer
"I need to learn how to input the mathematical expressions myself. "
What are you calling an "expression".
You asked for the percent.
This is what the sample calculated in the report.
Please clarify.
"Also I see in the provided sample that I manually have to input the number of days"
That is what the sample does.
You enter the date range, then you enter the number of days (There are three textboxes)
If either of these is not correct, then can you explain exactly how you want this system to operate, step by step?
Jeff
What are you calling an "expression".
You asked for the percent.
This is what the sample calculated in the report.
Please clarify.
"Also I see in the provided sample that I manually have to input the number of days"
That is what the sample does.
You enter the date range, then you enter the number of days (There are three textboxes)
If either of these is not correct, then can you explain exactly how you want this system to operate, step by step?
Jeff
ASKER
Hi,
By expression I mean common mathematical operators such as +, -, / and *. After I have returned a count from a query I would like to, lets say,, divide it with another count from a different query (which also returns a result to the same report). However, the result of this should be displayed in percentage.
How may I write this "expression" in a report?
Rgd manually having to input the number of days: I would like to only input two dates (date range) and based on this the computer should automatically count how many days it is btw the start and end date (no manually input).
rgds,
Stayer
By expression I mean common mathematical operators such as +, -, / and *. After I have returned a count from a query I would like to, lets say,, divide it with another count from a different query (which also returns a result to the same report). However, the result of this should be displayed in percentage.
How may I write this "expression" in a report?
Rgd manually having to input the number of days: I would like to only input two dates (date range) and based on this the computer should automatically count how many days it is btw the start and end date (no manually input).
rgds,
Stayer
But again, you asked for the percentage which is:
n/m
So I am still a little confused about why you would need other expressions.
Again, can you clearly state exactly how you want this system to function, step by step.
In other words, please explain, in detail, what my sample does not do, that you want it to do.
Note: Please spell out obscure abbreviations.
I have no idea what "Rgd manually..." means
I also no not know what you mean by : ("btw")
BTW is the abreviation for "By The Way" , not "Between".
Thanks
JeffCoachman
n/m
So I am still a little confused about why you would need other expressions.
Again, can you clearly state exactly how you want this system to function, step by step.
In other words, please explain, in detail, what my sample does not do, that you want it to do.
Note: Please spell out obscure abbreviations.
I have no idea what "Rgd manually..." means
I also no not know what you mean by : ("btw")
BTW is the abreviation for "By The Way" , not "Between".
Thanks
JeffCoachman
I think we are having a communications issue here, so let's start over.
Pleas explain *EXACTLY* how you need this system fo function step by step.
1. User opens the form.
2. User types in two dates.
3. User clicks a button and a report displays the number of days between the two dates in the Report footer.
4. ...ect
Pleas explain *EXACTLY* how you need this system fo function step by step.
1. User opens the form.
2. User types in two dates.
3. User clicks a button and a report displays the number of days between the two dates in the Report footer.
4. ...ect
ASKER
Hi boaq2000,
ok, this is what I`m looking for:
1. user opens form
2. user types in two dates
3. user clicks a command button, for instance View Report, and a report is displayed
4. in the report, I would like three things to be displayed
a) the number of days between the two dates
b) the number of records (I am not so interested in seeing the records connected to the dates)
c) percentage share, i.e: (# of records / # of days) = ..... %
Hopefully, this clarifies a little bit.
Best regards,
Stayer
ok, this is what I`m looking for:
1. user opens form
2. user types in two dates
3. user clicks a command button, for instance View Report, and a report is displayed
4. in the report, I would like three things to be displayed
a) the number of days between the two dates
b) the number of records (I am not so interested in seeing the records connected to the dates)
c) percentage share, i.e: (# of records / # of days) = ..... %
Hopefully, this clarifies a little bit.
Best regards,
Stayer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi boaq2000,
this was exactly what I was looking for!
thank you very much!
this was exactly what I was looking for!
thank you very much!
This solution helped me as well. Odd that the button wizard does not insert the correct command to open a report. - Thanks, boaq2000!
ejpren,
The Button wizard in Access 2007 and newer will insert a "Macro" to open a report.
In Access 2003 and older, in used VBA code.
The Button Wizard is designed to be very basic, so it will only open a Report.
It will not accept Filter criteria.
;-)
JeffCoachman
The Button wizard in Access 2007 and newer will insert a "Macro" to open a report.
In Access 2003 and older, in used VBA code.
The Button Wizard is designed to be very basic, so it will only open a Report.
It will not accept Filter criteria.
;-)
JeffCoachman
I used the button wizard to create a button to open a pre-defined report. It does not work. I downloaded boaq2000's database and used his command for his button onclick event for my button, and now it works.
OK
The button wizard should have worked, just try running the compact/repair utilityand see if the button wizard will work
The button wizard should have worked, just try running the compact/repair utilityand see if the button wizard will work
"number of days I have inputted in the form"
But if there was/is, it should be relatively simple.
New sample using USA date format (March 2009)
;-)
JeffCoachman
Access-EEQ-24288336-24299637Coun.mdb