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 Mike Lewis 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. RazorEddie

    Simple query gone wrong

    If I was still in IT running that department we would have 3 environments. I'll be getting access the production. I only need access to pull data, no insert or update or delete for this boy. I know better. Thanks for the help. He already told me he would get me access but it's not going to...
  2. RazorEddie

    Simple query gone wrong

    Still getting 0 records. I put in a request for direct access. Considering he once gave me the Administrator Password, I think he'll be happy to set me up a user account. I promptly forgot that password.
  3. RazorEddie

    Simple query gone wrong

    Unfortunately, the field I have to use is only to filter the record set. All I get when testing is whether the query executed and how many rows were returned. It doesn't show me any actual results. I have no direct access to the server for testing. I guess I'll go to the Server Admin and ask if...
  4. RazorEddie

    Simple query gone wrong

    Got rid of the errors but still returning 0 rows. SELECT [TDS Loans].Account AS LoanRecID FROM [TDS Loans] INNER JOIN [TDS Charges] ON [TDS Loans].RecID = [TDS Charges].ParentRecID WHERE [TDS Charges].Description='ASSIGNMENT FEE' It's supposed to return a list of Accounts AS LoanRecID to...
  5. RazorEddie

    Simple query gone wrong

    I'm trying to run a query against a DB I can't see, back end for a program. I have access to a access sample db that should be identical in structure. SELECT [TDS Loans].Account AS LoanRecID FROM [TDS Loans] INNER JOIN [TDS Charges] ON [TDS Loans].RecID = [TDS Charges].ParentRecID WHERE [TDS...

Part and Inventory Search

Back
Top