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.
Any ideas?
Right.
What I want to do is use a value obtained in the form (obtained from a list-box selection) to select a record in a table, then return one of the fields to a text-box on the form.
All the values coming from the list-box are unique, and the value returned is a simple integer.
Is there any way to do this reasonably simply?
I'm teaching this term, and have put my grades and roster in Access. Each grading opportunity is a separate field.
Students will have to take 3 exams (Exam1, Exam2, and Exam3); however, their grade is based only on the 2 highest exam grades. There are other grades...FinalPaper, Attendance, Paper1, Paper2... the total of the grades is 600 points.
I can do the other calculations... what I do not know how to do is to select the two highest test values from the 3 Exam fields. I coudl do it manually, but I really prefer to simply enter grades, and then have the final grade calculated.
Thanks.
Gayle Ann
Hi all - I have a table that contains Client ID, Supplier Name, Order Number, Order Date, and Price.
Example -
Client ID -- Supplier Name -- Order Number -- Order Date -- Price
1111111 Supp A 222222 1/2/06 1,000
1111111 Supp B 222222 1/2/06 2,000
1111111 Supp C 222222 1/2/06 4,000
1111111 Supp D 222222 1/2/06 500
1111111 Supp E 222222 1/2/06 1,200
I need to determine the 2 lowest prices per order number. In this case that would be Supp D - 500, and Supp A - 1000.
I am using the Top function and sorting the price in ascending order to get the lowest two prices. The problem is that it selecting the lowest 2 prices of all the orders on the table, not each individual order. I tried grouping on the other fields, but still came up with incorrect results.
Any ideas? Thanks!
B
I am working on a school database, today I am working for fee collection form and I am facing trouble.In attachment At the top right area the hidden field I would like here changes according to selecting Fee Type under Fee Detail. I want to achieve this,
If feetype is ABF then Hidden field = 1500110
If feetype is ASF then Hidden field = 1500120
If feetype is EXF then Hidden field = 1500130
If feetype is MTF then Hidden field = 1500140
If feetype is RBF then Hidden field = 1500150
How I can perform this ?
Table structure is
(tblstudents) Contain students data
(tblFee) Contain, Student Id linked with student table, month, year, amount, date, narratives and FeeType that looup values from FeeType tbl, this hidden field also in tbl fee.
The codes that are 1500100,1500120,1500130
These are necessary for GL entries that's why I must have it on my form. I had as well apply method of Default value but in that case I only present only a single value, but I want that in hidden field values take changes according to the fee type.
I have searched all the forms but could'nt find any answer which would help me , I have created a listbox , it works fine till the moment i set its 'Multi select' property to SIMPLE or EXTENDED , the minute i do that i get no results in my query , could someone please help me with this , i really really need to get this workin!! I have also uploaded my database so u could try it yourself...
View 11 Replies View RelatedI have a form that is a datasheet. it contains multiple records. One of the fields in that datasheet is a combo box. I would like to make it so when I select a value from the combo box it changes all the values of the other records in that column/field to what was chosen from that combo box. is that possible?
View 4 Replies View RelatedI am trying to use a list-control on a form to let the user select multiple values. I have understood that this requires some VBA-code to step through the selections in the list, since the "multivalue-selection" is set to "Extended".
When I try to execute the code I have (found and have tried to adjust), then I get the error message "Object required". The "ListCount"-paramater always only results in a ZERO-value, when i step through the code:
Function cmdOpenQuery_Click()
On Error GoTo Err_cmdOpenQuery_Click
Dim MyDB As DAO.Database
Dim qdef As DAO.QueryDef
Dim i As Integer
Dim strSQL As String
[code]....
I have some machine data to display showing running speeds. This is logged every minute when the machine is running but not when stopped.
how do I display a bar graph with a timescale along the bottom of minutes showing gaps when the mchine is down. :confused:
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 . . .
View 1 Replies View RelatedI 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:
Lane Carrier Price
..........
TN-FL Schneider $50
TN-FL JB Hunt $66
TN-FL Dart $78
646-303 JB Hunt $77
etc.....
Except of course in columns :) Any ideas on how to do this? Thanks in advance!
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 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.
View 10 Replies View RelatedHi
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
Ok, I have pesky solid line at the bottom of one field (bottom of the field with 6.80 in it..
I cannot figure out where it has come from or how to get rid of it!
Here's the properties for that particular field...
When I delete the column it appears somewhere else...
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.
View 5 Replies View RelatedI'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.
Is there any way to do this?
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?
View 2 Replies View RelatedI 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.
View 1 Replies View RelatedApologies if this is an obvious one but is it possible to hide this:
"Record:1 out of 34" and the arrow buttons at the bottm of a form(s)?
I would rather use my own Next Record and Previous Record buttons so it would dieal to disable/hide these arrow buttons.
Many thanks for your assistance in advance,
Paul.
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!!
View 11 Replies View RelatedIs 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.
View 2 Replies View RelatedI 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.