Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cdagenais

    Project 2003 - speech recognition problem

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

    Access unbootable XP HD with new XP HD

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

    Tryin to find top 5 results for 4 different values in a field.

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

    Tryin to find top 5 results for 4 different values in a field.

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

    Tryin to find top 5 results for 4 different values in a field.

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

    Tryin to find top 5 results for 4 different values in a field.

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

    Tryin to find top 5 results for 4 different values in a field.

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

    Tryin to find top 5 results for 4 different values in a field.

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

    Export then Import txt file problem

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

    average

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

    Can I combine two table fields into one object on a form?

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

    average

    lol, 2 for 1
  13. cdagenais

    average

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

    &quot;This action will reset the current code in break mode&quot; error

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

Part and Inventory Search

Back
Top