I'm trying to create a report that has three sections.
Section 1 = Planned Cost; Section 2 = Actual Cost; and Section 3 = % Variance.
I was able to build the first two sections easily with my query, but I'm having some trouble with the % variance part. Would I have to build that into the query itself, or is there an easier way to do it within the Access report fields?
Below I've included a mock-up (drawn in Excel) of what I'd like the Access report to look like.
Also, for reference, this is what the query used for my report looks like. Note: The original raw data looks a bit different, but I used a crosstab query in order to get the months of the year to appear horizontally as fields. (That's how I need my final report to look.)
I'm new to access programing and have been working on a handover form for shift workers, as part of the handover we have to include call volumes forcast and actual calls received over a period.
I have a form which links to my table (Handover) the two fields are named, "239 Forcast 18:30-00:00" & "239 Actual 18:30-00:00" I then want to add a third column with percentage variance to show wether the percentage of calls is higher or lower than forcast.
I manually input the data into the forcast and actual fields and want this to then populate a textbox for the variance percentage next to this.
So far I have tried: =Sum(100-[239 Forcast 18:30-00:00]/[239 Actual 18:30-00:00]*100)
The above sum seems to be a little unstable and when switching to view different handovers the value in the variance stays the same, regardless of the figures in the mentioned fields.
Is there a way to only highlight the last row of the detail section in a report?
I tried the following code in the "Format" but could not get it to work in Access 2010.
If Me.ClaimStatuses = "Total Potential Recoverable" Then Me.Section(acDetail).BackColor = vbYellow Else Me.Section(acDetail).BackColor = vbWhite End If
Where "ClaimStatuses" is the control text box and "Total Potential Recoverable" is the value I want to equal so this row which is the last row will be yellow.
I am creating barcharts in the report header section but i think there is some size restiction and I am not able to add more than 3 graphs in the report header section. I have to add 65 graphs. Is there any way to do that .
In the detail section of my report, I recently added a second row which has only 1 text field. When the value of the textbox in the 2nd row is null, I want the total row height equal to just the first row. When the value in the textbox in the 2nd row is not null, then the total row height is equal to row 1 and 2. I tried to make the textbox in the second row invisible when it had a null value thinking that when it was null, the report would shrink to the first row height, but that didn't seem to work.
We are creating a report and for some reason we can no longer extend the detail section of the report. It has stopped at 2 A4 pages length and won't let us extend it further. We have about 7 pages of the report, I didn't think this was too much?
I have a main report with 2 subreports. My main report has a header section, the 2 subreports are in the detail section of my main report. How can i prevent my report from splitting up my header and my subreports. (Header section of my main report is a company and the subreports are the detail of the company.. i don't want my compnay name on the bottom of a page and then the detail on the next page.. it does this sometimes. thanks!
I have a query with various entries, pertaining to various invoices. Each line of the query corresponds to a piece of work done, and there may be several lines in the query pertaining to one invoice. I've written the code to input data to a report.
If there are multiple lines in the query to be added to the one invoice, I don't know how to write code that will add those multiple lines in the detail section. Same type of data on each line, just basically pertains to several different lines of work.
Hi, i have poduced a report and i want to calculate some percentages. Some of the fields i have are:
Total Sales Clothes Shoes Pants
200 20 120 60
% 100% 10% 60% 30%
As you can see in total 200 sales were made, 20 clothes sales, 120 shoe sales etc and below it a percentage of each of the sale types. I have put this ' =Sum([Clothes]/[Total Sales])*100 ' in to calculate the percentage...but it does not work...Any help would me much appreciated :)
*This hasn't shown up very well...hope you understand it?!
Ive tried DVar but maybe Im not understanding the function correctly. I have a crosstab query that will only ever return 2 columns of data (sales for the current month and the previous month).
I want to add a column that will show the variance between these 2 columns. I can add a 'Total' column but can I add a variance column?If not a built in function any other custom function?
I have a table with the name of a report, the items on the report, and the number of items on the report. I would like to count the instances of the names of the individual reports that appear on another table and then divide that count by the number of items on the report.
I'm a Access novice trying to set up a table to record the answers to simple yes/no questions. I've got all the questions set up and yes/no fields set for their responses, but I now want to add a field that calculates the percentage of yes responses on that particular report and record that too. I'm trying to use the 'calculated' data type, but then I can't work out what to type as the expression.
I have a question about summing information on a report. I am developing a report to see have percentage of time Staff work within a certain area. On the data base the time percentages entered as ranges e.g. 75-100%, or 11-25%. We needed to figure out the total percentage of time so I created a report to add the total time. I used a text box which it titled FTE_Total if embedded iif functions to display the total time. Here is the function I used:
This worked perfectly however I cannot get the FTE_Total fields to sum. I tried the following function in the group footer: =Sum([FTE_Total]) but everytime I try to look at the report in report view I get a message asking for the FTE_Total Parameter.
I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried:
=sum([currentpaid]/[currentowed]) and it doesn't work.
to hide a subform on my form that is in the detail section of my form.
Is there a way to collapse or Hide the Detail section of the main Form??
I notice that their is a property under the Detail section called Visible with an option for Yes or No.. How would I manipulate that option through VBA? I am assuming that is the option that I am looking for
My report has the Section's Footer. Each time the section runs, it will take up a different amount of space. I have already run all the code, to move all the different controls to the top (and be invisible) when they are not needed. So to the best of my knowledge, I have no controls sitting in the lower part of the section. The last thing I run is: Code: Me.S123.Height = Me.S123.Height - 300 s123 is the name of the Footer SEctions. The idea is that it gets progressively smaller. This is all running in: Code:Private Sub S123_Format(Cancel As Integer, FormatCount As Integer)
All the other things work. Here is a sample of it all.. Code:If Me.txt2 = 0 Then Me.a2.Visible = False Me.b2.Visible = False Me.a2.Top = 0 Me.b2.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End IfIf Me.txt2 <> 0 Then Me.a2.Visible = True Me.b2.Visible = TrueEnd IfIf Me.txt3 = 0 Then Me.a3.Visible = False Me.b3.Visible = False Me.a3.Top = 0 Me.b3.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End If
This runs through 8 different numbers. as I said, all the other things operate properly. They get hidden and move.
I need to make a random schedule every week. I have a new DB that I have attached and the current one being used that was built by some one else. The reason for building the new one is I could not figure out what to change to add a new section/Area for scheduleing.
What I have are 3 levels of auditors
Level 1 are the basic auditors which I will need 1 per shift per day Level 2 Are operationl Auditors I will need 2 of the per week Level 3 are management auditors and I need one of those per week.
When I get these compiled per week I will need to make a report to e-mail out.
I attached both DB's the old one to show what I need, and the new for a more stripped down and easier to update version.
We have several users that access the same database. Is there a way to make it so that the users can add comments to the "coments" field on the form, but not remove any comments once saved?
I have made a table for prospective clients and want to add a notes section where I can add notes when I call them or they call me with the date. I have a comment section but thats not quite what I want. I would like them to be separated by date.
I am looking for the ability to have a scrollable window inside of a tab.
My database is tabbed into categories of data.
One of these categories has more than the others.
I would like to create a rectangle inside the tabbed area which I can put the questions in but the box is too small, so instead of creating tabs inside another tab, id rather have a scrollable section inside in which I can put the questions in...
