Search results

Still not right and there is no query3 in the database? I still can't see the -8 value?

Still problems I now don't see the -8 value on the report....can you still help pls?

Greatest Values Questions .Source = "Select TOP 5 [Name],[StuDiff] From QryCover WHERE (((QryCover.StuDiff)>=2)) OR (((QryCover.StuDiff)<=-2)) ORDER By ABS([StuDiff]) DESC" I can get the numbers but now it needs to be in name order and not studiff. If I put it in name order then I get the...

No that did not work I still don't see the values after the -8.

No I thought I just put it on here. Sorry

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.

Here is the list I have in the field: SupDiff 0 0 0 0 -1 0 0 -2 0 0 -1 2 -1 0 1 0 -1 0 0 0 0 0 0 -1 0 1 -2 0 0 0 -1 0 0 0 0 0 2 0 0 0 -8 0 1 0 0 1 0 0 0 0 0 0 -2 0 -1 1 -5 0 0 -1 0 0 1 -1 0 0 0 0 -1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 -2 0 0 0 0 -1 I need to find the 5 biggest values not...

Greatest Value Question I still don't see the -5 value I need. Out of the top 5 it comes out at number 7 behind Showing up now: -2 2 -2 2 -8 next 3 that will show up: -2 -5 -2 As you can see that the -5 should show up in the list.

Greatest Values ok here is and example: I have 0 -1 -2 -8 -4 -5 -6 -7 -8 -8 -9 -9 -1 0 -2 -3 Out of that I need to get -7 -8 -8 -9 -9 and not just get the first 5 values.

Greatest Value Question That is not the problem, the problem is that I have about 94 records in the field and it is getting the first 5 it comes to that are >=2 or <=-2..... it finds now: -2 +2 -2 +2 -8 And then in a field about 20 down from the last I see a -5....I need to know how to get...

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.

Convert to ADO Thank you very much.

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

VB Script Help Can you modify the code for me and repost it?

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.

Well I want all the results to be on one line not multiple lines for each record. How can I do that?

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