Search results

Here is a example of my database can someone please look at it and tell me how to get the top 5 values from the query. not the first 5 highest but the highest out of all the data.

If I using this line of code to try to pull out the top 5 values from a query: .Source = "Select TOP 5 [Name],[SupDiff] From QryCover WHERE (((QryCover.SupDiff)>=2)) OR (((QryCover.SupDiff)<=-2)) ORDER By [Name]" It works fine but what I need to know is how to find the greatest vlues in the...

How can I sort this code ascending or descending order? .Source = "Select TOP 20 [Name],[Alloc],[Total] From QrySML WHERE QrySML.Alloc>=100 ORDER By [Alloc]" Where would I put the sort order?

I need to know how to insert a new column in a table with a ADODB command. I tryed the append but it will not work.

Can someone help me convert this code to ADO form DAO please? Function GetPermissions() Dim TheDb As Database Dim TheTable As Recordset Dim TheForm As Form Dim TheGroup As String Dim TheUser As String TheUser = "Username = '" & CurrentUser() & "'" Set TheDb =...

I am trying to use this code to print in a report but it give me the following error. The Value you entered isn't valid for this field It is because I am getting the top 3 values from the query and only 1 is showing up on the report. I need the other fields to just be blank if there is only 1...

Can anyone tell me how to do this? I am trying to import them into a table. Without having to rename them.

I have fields on a report the I need to Count the number of times a person use different things. PC TV PHONE ETC. I have a input form with a pull down menu to select one of the above. Now on the report field. I want to fills the 4 fields by sorting by SSN and TYPE. So how do I...

I am trying to use the following code in a macro to set the value of a textbox. I am using the SetValue command in the macro: Item = [Forms]![FrmCharge-In]![IDII] Expression = DLookUp("[TypeID]","[Master Table: Type]","[TypeID]=" & DMax("TypeID","[Master Table...

I have a make table query and know I need to change the field types to Data/Time,Short Time when the table is created. Can anyone tell me how to change the Data Types of the fields? This is all being done in Access 2000. Ty [This message has been edited by Beerman3436 (edited 08-10-2000).]

Does anyone know how to have a report that will place a number beside the top ten people on the list. The list has over 50 people on it and the total number of calls they have received. What I need is for the system to look at the totals and then put a 1 beside the person with the highest total...

Does anyone know how to have a report that will place a number beside the top ten people on the list. The list has over 50 people on it and the total number of calls they have received. What I need is for the system to look at the totals and then put a 1 beside the person with the highest total...

I have a report that lists names down the left hand column and the months across the top. This report so me how many calls each person got for each month. This report is based on a Crosstab Query. What I need to do is add a new column on the report that will put a 1 thru 10 beside the top 10...

I need to know how to produce a report by name and month. What I have is records that are assigned a date i.e.(03/29/00), and one or more names are assigned to this record for that date. I need to produce a report that will list each name, and each month, and the total record each person has...