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!

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

Recent content by tonyblack

  1. tonyblack

    Two Graphics Cards

    For further info on running multiple monitors on Vista have a look at: http://www.microsoft.com/whdc/device/display/multimonVista.mspx
  2. tonyblack

    Two Graphics Cards

    SLI is not a requirement for running multiple graphics cards/monitors. I am running a four monitor system on Vista Business using 1 x NVidea GForce 6200 256MB AGP card and 1 x NVidea GForce 6200 256MB PCI card. This setup works fine. The only limitation i am aware of (and this is from personal...
  3. tonyblack

    IDE components sections greyed out

    I should add that i am using Visual Studio .Net 2003
  4. tonyblack

    IDE components sections greyed out

    Hi, All of tool bars in my Visual Studio.net IDE are greyed out except for 'Device Controls'. I have tried selecting the tools I needed using the Toolbars menu on the view menu bar. When I open the customize menu from Toolbars menu, all the tool bars appear and when I close the customize menu...
  5. tonyblack

    Finding the next value after the minimum

    Could you clarify: iif(minTime = #01:00:00#, dlookup(minTime, tblName, minTime > #01:00:00#), minTime) Should i swap 'tblName' for the name of the query that this report is based on?
  6. tonyblack

    Finding the next value after the minimum

    I hope this clarifies things. I need my report to look like this: ID KG Picked MinTime MaxTime 151319 109.55 09:41:00 14:27:00 150743 107.38 08:49:00 15:21:00 150859 103.55 09:44:00 15:17:00 150841 94.29...
  7. tonyblack

    Finding average of top 10%

    From the sample query result below i need to be able to report the total average KGs Picked by the top 10%, 50% and 75% of IDs listed. Picker ID KGs Picked 151319 109.55 150743 107.38 150859 103.55 150841 94.29 150878 90.46...
  8. tonyblack

    Finding the next value after the minimum

    From the query result below i need to be able to state the earliest scan time from the 'MinTime' list and the latest scan time from the 'MaxTime' list. I have achieved this using Min & Max in my report but i have a problem in that i need to ignore any MinTime that is entered as 01:00:00 and find...
  9. tonyblack

    querying based on interval between datetime

    I have a table with the following 4 fields: DeviceID (number) LabID (number) LabSer (number) Transtime (DateTime - ##/##/#### ##:##:##) I need to create a query that will identify table records that are duplicates for the first three fields, the date part of Transtime is a duplicate...

Part and Inventory Search

Back
Top