Search results for query: *

DUH !!!!! AFTER I posted the above, I compared the SQL, and noticed that your TRANSFORM First(tblExcelImport.A) AS FirstOfA would translate to... TRANSFORM First(tblExcelImport.EmplData) AS FirstOfA Once I made this change, it worked! Thanks, Duane !

Hello Duane, The SQL isn't working. Here is what happens when I create a query based on the table -- to show you the field names. SELECT tblExcelImport.ID, tblExcelImport.EmplData FROM tblExcelImport; I pasted your crosstab into the query SQL view, and received this error: "The Microsoft...

I have a large Excel file formatted thus; COLUMN A 1 Full Name 2 Full address 3 City State Zip Columns B and on have other information for the employee in Column A, and is located on the same row as the City-State-Zip. I need to get the employee information in Col A into a tabular form, such...

Rollie, thanks for responding. I apologize for not explaining myself very well. There are two criteria that must occur before the COUNT field is changed from YES to NO; 1. The cboAction selected must be DEPARTURE 2. The txtDateCompleted cannot be Null (must have a date input). So, on the...

Greetings, I need to have something that happens on a tabbed subform to change the value of a textbox on the main form. ********************************************************* MainForm = f_Employees MainForm textbox = txtCount Tabbed Subform = fSub_Personnel_Actions_subform_2 Tabbed Subform...

Greetings, Management wants to see who is doing what type of input in a given period of time. I've gotten the information saved to Excel, which returns the timestamp that the employee input a certain document into the system (document types can be PO, INV, RR, MOD). I've managed to split the...

<quote>&quot;One more thing SR1? For the sake of sanity get SR2!<endquote> I work for Uncle Sam. Sadly, I have no control over anything concerning my PC nor the software. Access 97 SR1 &quot;seems&quot; to work fine. What advantage does SR2 have? Thanks, Bob in Indy

Greetings, Have questions on Table design and Relationships. Using Access 97 SR1. I have Time & Billing info that I'm working with. Every 2 weeks, I receive a new batch of data. It arrives as an Excel spreadsheet, which I convert to CSV. I then import into Access using an Import Spec...

Rick, This is my first opportunity to post again. Your solution didn't work...but I suspect it's not your fault. I don't pretend to understand how this happens, but there was ANOTHER query....a DELETE query, where the APC criteria also existed....and I had to ensure that the same criteria from...

Rick, Thanks for the quick reply! I'll give it a try and see what happens. Bob in Indy

Using Access 97 SR1 Greetings, I've inherited an emergency that I cannot seem to resolve in a payroll database. The DB is run strictly from Macro's. Hoping someone can help with this ASAP, as this process must be run this morning (Now 08:20 in Indiana) I need to add two APC codes to the 3...

John, Thanks for your reply. Interesting concept. I gather that you would create a table containing all of the error types that I can identify, and using 2 queries, run this against the main table. So, if my new table (ErrorTrap) looked something like this...: Priority1 Priority2...

John, Thanks for your reply. I think I have an idea how to do the report, of which some are for management analysis, others for error corrections in the Time & Billing system. Have you any ideas how I can use multiple IIF statements within a query?

Work-Access 97 SR1 Home-Access 2000 Greetings, Apologizing for the long post. Analyzing Time and Billing. I receive a flat file in Excel every two weeks, which I append to an Access file. A large portion of the analysis is capturing errors between the HourTypeCode and WC5. As of now, I have...

Sashanan, Not a complete answer, but it may get you on track. I had an occassion where I needed to compare the values in two fields to see if they were equal. The expression would then display &quot;Increase&quot; or &quot;Decrease&quot; or &quot;Equal&quot;. Anything not &quot;Equal&quot; was...

Bob, Works like a charm! Thank you. Now, where can I learn exactly the dirrerent elements of this expression, and what the difference is between MID and MID$. Thanks Again !! Bob in Indy

scriverb, Thank you for your reply. After I implemented the expression, I've now learned of a new &quot;fly in the ointment&quot;. I'm comparing the Organization that is in that long string of data to the Organization data in another field, as some employees are using the incorrect Org codes...

Hmmm.....I've now made it work !! Expr1: Trim(Mid([WC1],InStr(1,[WC1],&quot;_&quot;)+1,IIf(InStr(InStr(1,[WC1],&quot;_&quot;)+1,[WC1],&quot;_&quot;)=0,0,InStr(InStr(1,[WC1],&quot;_&quot;)+1,[WC1],&quot;_&quot;)-InStr(1,[WC1],&quot;_&quot;)-1))) By adding the -1 at the end of the expression, it...

scriverb, Close <smile>. I also want to exclude the underscore at the end of the data. My goal will be to have the following returned: ADFGI (No underscores). The data I'm extracting from the field is the Organization Code. I'll then be comparing it to another field looking for errors...

Access 97 SR1 Greetings, I have a field that I'm trying to extract a portion of the text. I'm using this expression, but it's not returning what I need. WC1...