Search results

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).]

I tryed it with this but it gives me a ORDER BY error. Private Function TopTen(ByVal IncidentID As Long) As Variant Dim rst As Recordset Dim strSQL As String strSQL = "Select Top 10 [IncidentID], Count([IncidentID]) from [QryMonth_Crosstab] order by Count ([IncidentID])asc Group by...

That did not work. I only need for the top 10 people with the most calls to have a number beside their name.

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 that now. Now do you know how I can put a new column on the report that will put a 1 thru 10 for the Top 10 people. If I have 200 people on the report then I only want the numbers to display on the top 10 people. Not all 200 of them.

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...