In the tutorial whose link I have shown below: URL....The graphs that I create from the tutorial always have the legend on the right side. I would rather have the legend running along the bottom of the graph. I have two questions :
1. The graphs that I have already created, how can I get the legend to move down to the bottom of the graph? What command can I use?
2. When creating new graphs how do I make the legend go on the bottom of the graph and not the right side.
i have a table with 7 columns. Assume THE columns are a,b,c,d,e,f,g. In this table there is only one row and each column is given a number value. For example, a is 1, b is 5 and so forth. Can i make a pie graph in access with these 7 labels, and show there totals in the graphs?
Hi, I have table (Table A) whose column (Column A) is a lookup table linked to Table B. Column A's type is of number. Table B has 2 columns. Column B1 is of type autonumber (set as primary). Column B2 is of type text. When I am populating Column A, I select from a drop down list which shows the values of Column B2. Column A will populate with what appears to be Column B2 values. However, whenever I create a chart with Column A, the values in the legend always show the numeric value of Column A, not the values of Column B2 as I want. This occurs in pivot charts as well. Here is an example:
In this case Table A = A_Incident_Main_Table Column A = A_Incident_Main_Table.System_Name
TRANSFORM Count(*) AS [Count] SELECT (Format([Date],"mmm"" '""yy")) AS Expr1 FROM A_Incident_Main_Table GROUP BY (Year([Date])*12+Month([Date])-1), (Format([Date],"mmm"" '""yy")) PIVOT A_Incident_Main_Table.System_Name;
Here is another example:
SELECT A_Incident_Main_Table.System_Name, Count(*) AS [Count] FROM A_Incident_Main_Table GROUP BY A_Incident_Main_Table.System_Name;
A_Incident_Main_Table.System_Name is poplulated in with values from the lookup table (Table B). In both examples, I see only the numeric values in the legend, not the text values of Table B.
I have a query that pulls information from a combo box in my form, now I've made a pivot form to report the outputs, however my legend will only display the first two letters of word... I need to show the entire word.
Hi all! I have a tough problem I was hoping I could get some help with:
I would like to create a recordset based on the "middle" 50% of the data. I need to chop 25% off the top of the data, AND 25% off the bottom of the data.
I've got a label in a report which I'd like to have a bottom border only. Looking in the property sheet I don't seem to see this option (nor in the ribbon). Is there a way to do it other than with a line control? I'd like to have it attached to the actual border of the label . . .
I have a database with information on carriers, lanes, and prices. I need to choose the cheapest 3 carriers for each lane. The lanes are either 3-digit zip code to 3-digit zip code or state to state (410-300 or CA-GA, etc.) So for each of these lanes, I need to find the 3 cheapest carriers all in one query. So the resulting table should look like:
I have imported a table into a form and would like to know how to remove the navigation options from the bottom of the table, I know you can do it for the form but can you do it for a table contained in a form.
I have created a query which sorts store information by potential opening dates...however, some of the stores are so new there are no potential opening dates as yet.
I would like the stores with blank opening dates to appear at the bottom but when sorting by ascending (which is what I need) these blank dates appear at the top... is there any way around this? thanks
I have reports that total the figures in a column and displays the total at the bottom of the column. I would like to display the total at the top of the column since the length of the column continues to grow and I would like to see that total before scrolling down to view the various individual entries.
No matter how I try the =count(x) always shows an error. Is it not possible to display the total figure at the top of a column instead of at the bottom?
Is there a way of formulating statistics at the bottom of a report?
Heres what i have.
The report pulls Rank, Last Name, First Name, Assigned weapon, Weapon qualification date. After 6 months i use conditional formatting to highlight the soldiers qualification date red. Im in the military that's why im tracking all this, but I need figures to report to higher, and at the bottom i would like it to show, "#Qualified", "#UnQualified","% Qualified", "% Unqualified", "#Expired","%Expired"
I have a sub-report and the last row is highlight, however, there seems to be extra spacing after the last row. I removed all report/page header/footer so all what's left is the Detail section but I still have this white space after the last row.
I'm finishing off a database project and would like to do some final tidying up. I'm using subforms on some forms and these subforms show a black line on the bottom edge, I would like it to be white so it blends in with the back and the user doesn't know it's a subform.
I have a continuous pop up form which, at the most, will contain about 10 records. The ten records take up less than half the screen space - but there is a bottom half to the form - even though there is nothing there. How can I get rid of the unused space on my form?
I am using MS Access 2003.I have a report whose Detail band contains a zero-height Comment field positioned at the bottom of the other single row of fields. It has Can Grow = Yes, so it sits waiting to grow if there's any data in this Comment field.
However, when this report prints, if the Comment field just "happens" to straddle two pages, it gets positioned only on the first page and gets cut off in the process. (See attachment 2.) Ideally, the entire field should display on the second page instead.
If I adjust the margins in Page Setup, I can fix this on this particular report. However, depending on the data being reported, these new margin settings can create a problem for the same report with different data. (All depends on where the Comment falls.)I'd like the report to work consistently, no matter the data or margins.
I have some columns with hours. I want to simply display the total below each column. I would like to do this in the query results and in the reports that I create.
I got a form / subform relationship.how to locate the bottom record, when the user after some queries input at the main form. I desire to display the bottom end record (EOF), instead of some sorting and display the last record at top of the subform!!
Is there a way to have a datasheet open with the last record at the bottom of the page? I now have it opening to the last record, but it has the last record at the top and can't see the records before it without scrolling.
I recently found a neat little module which allows you to duplicate a right click & bring up pop up menu ( say by left clicking on a field). I find this very good for creating a nice little menu system in which I can reproduce the nice features of Access menus (I'm using Access 2002) but with a lot more flexibility.
So, I have a line of labels across the top of the form which are my top level menu items - when I click or mouse over these I want to have the pop up menu appear directly under the label. I can position the pop up menu manually by SetCursorPos(x,Y) but as my forms are Pop Up and can move this has proved to be a pain.
What I am after is something that will allow me to work out the coordinates of the left bottom of the label and then position the cursor there then drop the menu. The difficulty I'm having is converting or understanding the position of the label (me.label1.left etc) and relating that to what SetCursorPos needs.
I created a report that only has gridlines around the outside border of the entire report (rather than around each record). I want the grid line style on the last/bottom record to be solid so it boxes in all the records. When I change the "Gridline Style Bottom" for the records, each record has a bottom gridline rather than an outside box around all the records.
I have a report which is grouped by employee number - each group can have one or many records displayed - it works fine, but can look untidy sometimes when there are more records than will fit without wrapping onto another page; this is particularly prevalent when there are two or three groups - the third one may run over onto the next page, without group headers.
Is there anyway to force a page break at the bottom of a group if that group is not going to fit on the current page in its entirety?
see below the code . The select statement searches the Printpoolno value from the top to bottom in table tblmaster. As in my table tblmaster there are thousands of records and it takes long to search for that Printpoolno from the table . Is there anyway we can write a query that will search the table from bottom to top as the Printpoolno will always be in the bottom records and not in the top records.
Code:
Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim r As Long
