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

    Case Sensitive query

    Yes cheers works fine!
  2. crashevans

    Case Sensitive query

    Hi I want to search a table for a case sensitive result e.g. "Blue", however it currently returns this result whether I search for BLUE, blue etc. I am using Microsoft Access. The query I tried - SELECT * FROM User WHERE Password = 'Blue' Thanks for help in advance.
  3. crashevans

    Case Sensitive search

    Hi I want to search a table for a case sensitive result e.g. "Blue", however it currently returns this result whether I search for BLUE, blue etc. I am using Microsoft Access. The query I tried - SELECT * FROM User WHERE Password = 'Blue' Thanks for help in advance.
  4. crashevans

    Aggregate Function

    Hi all I get the following error.. You tried to execute a query that does not include the specified expression 'Mark' as part of an aggregate function Code - SELECT TestID, Max(DateCompleted), Mark FROM UserTest WHERE ServiceID = 'G000000G' GROUP BY TestID; However I dont want to group by...

Part and Inventory Search

Back
Top