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