Search results for query: *

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.

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

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.

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

...= LAWDB2_PERSACTHST.COMPANY) WHERE (((LAWDB2_PERSACTHST.ACTION_CODE)="TERM") AND ((LAWDB2_PERSACTHST.REASON_01) Like "TER*") AND ((Month([EFFECT_DATE]))=[Forms]![frm_intro]![month]) AND ((Year([EFFECT_DATE]))=[Forms]![frm_intro]![year])); someone suggested that I take off the TER*. I did...

Nope...no code in the form.

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

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

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

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.

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.

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

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

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

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

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

Yes, that works in an MDB file. Expr1: Val(Format([calc1],"Fixed")) Unfortunately, I was working with 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...

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

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'