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: *

  • Users: psimon88
  • Order by date
  1. psimon88

    unique records causing Access to loop

    Yes.... that's the crazy thing. I removed the TER* and left(reason,3) = TER and tied it to another query. I'm really baffled. Thanks again.
  2. psimon88

    unique records causing Access to loop

    So, would you guys recommend creating a temp table? Reporting off of static data would solve the problem, no?
  3. psimon88

    unique records causing Access to loop

    Yes.... that's the crazy thing. I removed the TER* and left(reason,3) = TER and tied it to another query. I'm really baffled. Thanks again.
  4. psimon88

    unique records causing Access to loop

    Yes, it is another query SELECT qry_EMPLOYEE_FIELD1.COMPANY, qry_EMPLOYEE_FIELD1.PROCESS_LEVEL AS STORE, qry_EMPLOYEE_FIELD1.EMPLOYEE, qry_EMPLOYEE_FIELD1.LAST_NAME, qry_EMPLOYEE_FIELD1.FIRST_NAME, qry_EMPLOYEE_FIELD1.EMP_STATUS, qry_EMPLOYEE_FIELD1.DEPARTMENT, qry_EMPLOYEE_FIELD1.[DEPT NAME]...
  5. psimon88

    unique records causing Access to loop

    I am running a report in Access 2003 off of DB2. I am pulling multiple records for an event and am using 'select unique' to pare them down. Unfortunately, when I do this, it causes Access to loop. My time-out setting is 600 seconds and the data set isn't that large (2,000 records). Anyone...
  6. psimon88

    unique records causing Access to loop

    Nope...no code in the form.
  7. psimon88

    unique records causing Access to loop

    OK...you asked for it! :) Thanks *************** SELECT DISTINCT qry_EMPLOYEE_FIELDTERMS4.COMPANY, qry_EMPLOYEE_FIELDTERMS4.STORE, qry_EMPLOYEE_FIELDTERMS4.EMPLOYEE, qry_EMPLOYEE_FIELDTERMS4.LAST_NAME, qry_EMPLOYEE_FIELDTERMS4.FIRST_NAME, qry_EMPLOYEE_FIELDTERMS4.EMP_STATUS...
  8. psimon88

    unique records causing Access to loop

    It's a select query, not an update or MTQ one. I'm not sure that I follow the question.
  9. psimon88

    unique records causing Access to loop

    Hello I am running a report in Access 2003 off of DB2. I am pulling multiple records for an event and am using 'select unique' to pare them down. Unfortunately, when I do this, it causes Access to loop. My time-out setting is 600 seconds and the data set isn't that large (2,000 records)...
  10. psimon88

    Word help - removing carriages

    There must be a way to do this. I have to stitch together two separate pdfs and it's cut and paste hell. In particular, I have to manually remove all of the carriage returns. I wasn't sure if there's some VBA out there to do this. Any thoughts/hints would be enormously appreciated.
  11. psimon88

    ranking data on an ADP (TSQL)

    Thank you. Is inview a function or is the name of the view that I am creating? Also, when you write A, is the original table or is that the new view that I am creating with CREATE VIEW? Thank you.
  12. psimon88

    ranking data on an ADP (TSQL)

    Thanks for the response. SELECT dtmED_Caller_TimeStamp, lApplicationID, count(*) as count FROM dbo.ED_Caller_VM_Leads WHERE (lApplicationID = 190) group by lApplicationID, dtmED_Caller_TimeStamp provided only: dtmED_Caller_TimeStamp, LAPPLICANTID, COUNT 2004-10-01 07:26:36.420...
  13. psimon88

    ranking data on an ADP (TSQL)

    Hello I was wondering if someone could help me out. What would be the best way for me to go about determining the sale number from the following table: applicantID calltime result 1 1/5/05 no sale 1 1/15/05 no sale 1 1/25/05 sale 1...
  14. psimon88

    macro to import objects from another ADP file?

    Maybe I missed it, but the arguments there let you specify which objects you want to import?
  15. psimon88

    macro to import objects from another ADP file?

    Hello I have administrative rights over an ACCESS 2003 ADP file. It's a backup of PROD data. I report off PROD data but have to manually import the objects into PROD each time to run the reports. I don't have the ability to permanently save objects on the server. Is it possible for a...
  16. psimon88

    searching for a word in a string

    Thanks. Is there a good site/reference place to investigate all of the differences. This would expedite my learning. Thanks.
  17. psimon88

    convert to percentage

    Yes, that works in an MDB file. Expr1: Val(Format([calc1],"Fixed")) Unfortunately, I was working with an ADP.
  18. psimon88

    Pros / Cons to using an ADP

    Hello I am still wondering why certain things are so different between MDB and ADP files. For example, see: http://www.tek-tips.com/viewthread.cfm?qid=1122630&page=1 I thought that an instr function would suffice here (ADP file). In the MDB, it took me two minutes to get this: SELECT...
  19. psimon88

    searching for a word in a string

    'instr' didn't work for me in MS Query Analyzer (SQL Server 2000). I had email address and wanted to pull domain (all characters after the '@'). I thought that this would work: strDomain = Right$(strEmail, Len(strEmail) - InStr(1, strEmail, "@")) ERROR MSG: 'InStr' is not a recognized...
  20. psimon88

    Know how to delimit data in SQL?

    Thank you. You'd think that that's it, right? 'instr' is not a recognized function name. SQL Analyzer running off SQL Server 2000. Instead, I got it with this: right(stremail,(LEN(strEMail)-CHARINDEX('@', strEMail))) as 'domain'

Part and Inventory Search

Back
Top