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...
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.