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 Chriss Miller 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. indyaries

    Horrible Excel File Woes

    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 !
  2. indyaries

    Horrible Excel File Woes

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

    Horrible Excel File Woes

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

    Form-Subform Referencing

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

    Form-Subform Referencing

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

    Getting time into crosstab?

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

    Table & Relationships questions

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

    Table &amp; Relationships questions

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

    Query Emergency !!!!!

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

    Query Emergency !!!!!

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

    Query Emergency !!!!!

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

    Multiple IIF statements in Query

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

    Multiple IIF statements in Query

    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?
  14. indyaries

    Multiple IIF statements in 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...
  15. indyaries

    Preventing calculated field from exceeding value in another column

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

    Parse a field

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

    Parse a field

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

    Parse a field

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

    Parse a field

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

    Parse a field

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

Part and Inventory Search

Back
Top