Search results for query: *

Go into Microsoft Office under Add/Remove Programs. Then UPDATE the install. Do a custom modification, and look at Shared Tools. Then Alternate Input Devices. And then select Voice Recognition, and give it a big cross. Then say OK. This should fix it. Cindy http://www.aslconsulting.com/EN/Index.asp

Here is the situation. My old, itsy bitsy hardrive wouldn't boot up anymore so I bought a new one and started from scratch. I have the second one set up as a slave, and I can browse all of the files on the old Hard drive. However, when I try to access My Documents I get "accessed denied." I...

SELECT TOP 5 BossID, * FROM Table WHERE (((BossID)="ABC")) ORDER BY Count DESC Union SELECT TOP 5 BossID, * FROM Table WHERE (((BossID)="123")) ORDER BY Count DESC Union SELECT TOP 5 BossID, * FROM Table WHERE (((BossID)="DEF")) ORDER BY Count DESC Union SELECT TOP 5 BossID, * FROM Table WHERE...

Could you post an example of the values stored in your table and how you would like the query to display them? Just to make sure we can answer this question right for you. Cindy http://www.aslconsulting.com/EN/Index.asp

ha...that's interesting!!???? :) 2 for 1 Sorry about that. Cindy http://www.aslconsulting.com/EN/Index.asp

Actually, that might not work. There is a risk of getting more than 5 records ( I tried it and got 7 ) The results would be more accurate if you created 1 query for each column using: SELECT TOP 5 Grapes, (SELECT count(*) from TABLE d Where Table1.Grapes <= d.Grapes) AS RowNum FROM TABLE ORDER...

Actually, that might not work. There is a risk of getting more than 5 records ( I tried it and got 7 ) The results would be more accurate if you created 1 query for each column using: SELECT TOP 5 Grapes, (SELECT count(*) from TABLE d Where Table1.Grapes <= d.Grapes) AS RowNum FROM TABLE ORDER...

SELECT TOP 5 * FROM TABLE ORDER BY APPLES DESC UNION SELECT TOP 5 * FROM TABLE ORDER BY ORANGES DESC UNION SELECT TOP 5 * FROM TABLE ORDER BY GRAPES DESC UNION SELECT TOP 5 * FROM TABLE ORDER BY PEARS DESC; This will sort from highest to lowest for you Cindy...

Not sure if this will work but try this: After you import the data, use an update query to update the date using: Date1:Format(CDate([DATEBRTH]),"dd/mm/yyyy") Cindy http://www.aslconsulting.com/EN/Index.asp

Thank You for the Star! Very Appreciated! Cindy http://www.aslconsulting.com/EN/Index.asp

In the control type =[LName] & ', '& [FName] Hope that helps!! Cindy http://www.aslconsulting.com/EN/Index.asp

lol, 2 for 1

Is this what you are looking to do? I just used the Totals functionality of Access. SELECT treatment.HOSP_NO, treatment.TREATDATE , treatment.SURNAME , treatment.FIRST_NAME, treatment.[DIAGNOSIS GROUP], treatment.Embolised , treatment.TRT_VOLUME , treatment.LESION , treatment.PREV_RS ...

Hi, I'm having a similar problem in Access 2000. A simple select query will run, then not run. Did you find a solution?