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 Rhinorhino 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. DaveButler

    Data encryption

    I don't want to simply hide data on the screen. I want to store encrypted data in the database. Thus, if you saw the data from Access' Table view, you'd see garbage in the cells with encrypted data. In order to decrypt the data, you would need the encrption key (i.e. password) and the...
  2. DaveButler

    Data encryption

    For security reasons, I need to encrypt the data in a particular column. Is there a built-in routine or some simple method to achieve this? The app will have an encryption key available for the encryption/decryption. Thanks!
  3. DaveButler

    Need help composing a difficult query

    Access doesn't like that Oracle syntax. Through trial and error, I have determined that Access prefers this format. SELECT * FROM TABLE1 WHERE COL1 & COL2 IN (SELECT COL3 & COL4 as blah FROM TABLE2 WHERE ...) Gotta love it. Thanks to all for your input.
  4. DaveButler

    Need help composing a difficult query

    Thanks to everyone for their input! Angiole's solution was the following. Select * From LineItem Where OrderNum in ( Select OrderNum From LineItem Where ProductID = 'X') How would it differ if you needed to compare two columns in the main query with...
  5. DaveButler

    Need help composing a difficult query

    Are you a competent SQL developer? If so, please help me compose this seemingly simple, yet tricky, query. Assume the data structure in question is the typical Order and LineItem. For each Order row, there are many LineItems associated with it. I need for the query to return *all* LineItem...

Part and Inventory Search

Back
Top