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 Wanet Telecoms Ltd 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: *

  • Users: telford99
  • Content: Threads
  • Order by date
  1. telford99

    Count Unique items between two dates

    I have the follwoing quere SELECT COUNT(*) AS Workstation_Count FROM [SELECT DISTINCT Workstation_ID FROM Machine_Connect]. AS [%$##@_Alias]; I want to count the number of unique items in the DB between two dates. There is also a date field in the db. I'm using SQL - MS Access. Thank you in...
  2. telford99

    Order by particale date

    Can someone please help me with this. I'm very new to SQL I've got a DB with a couple of field workstationID Date added, notes. I need to collate the information into days. ie we added X workstation on this day. So for each day I can get the total workstations added Is this possible, please...

Part and Inventory Search

Back
Top