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

    Help normalizing & combining fields?

    Hi Larry, The original datasheet is in Excel. However, I've already exported a copy of it to Access (where it is in table format). In the Excel sheet, the Header line contains all these fields: Case#, ProbA, MethodA, OutcomeA, ProbB, MethodB, OutcomeB, ProbC, MethodC, OutcomeC, ProbD...
  2. sarajini

    Help normalizing & combining fields?

    Hi Larry, Sounds good! My big problem, however, is in separating the info into tblCases and tblSituations. I don’t know how to start dividing the Situation info (ProblemA, MethodA, OutcomeA, ProblemB, MethodB, OutcomeB, Problem C, etc). The information should end up in a nice, neat...
  3. sarajini

    Help normalizing & combining fields?

    Hi All, I am looking for advice on normalizing a table imported from Excel. The Excel table lists information on cases that our clients have. Each case can have 1-4 situations. Each situation has three components: a problem, a method, and an outcome. Right now, the Excel table has an...
  4. sarajini

    Date calculation: help with DateDiff() syntax?

    Hi Kevin/Godawgs... The N/A bit of the code is working fine. Unfortunately, for cases with existing close dates, I'm still being asked for year, mo, day parameters, and getting #Error in the TimeTaken column. Hmm.... SELECT cases_tbl.CaseNumber, cases_tbl.DateOpen, cases_tbl.DateClose...
  5. sarajini

    How to normalize/parse fields? Problem with Instr() syntax

    Hi Kevin! Ugh, Access…the code’s still being balky. I entered what you had written. When I tried to run the query, I was asked for parameters for Advocate1 and Advocate2. The recordset had fields for Advocate1 and Advocate2, but the fields were all blank. When I tried to run the query from...
  6. sarajini

    Date calculation: help with DateDiff() syntax?

    Hi Tek-Tips folks! My office has a table with information on cases. The table has fields for each case’s open date and close date. We’d like to get a new field, “TimeTaken,” with the time (in year-day-month format) between the case’s open date and close date. I know that DateDiff can help me...
  7. sarajini

    How to normalize/parse fields? Problem with Instr() syntax

    Hi Maq, I get this message: "Syntax error (missing operator) in query expression," then it restates the code from the first Iif to the end. I don't know how helpful that is to you. Thanks for trying to work with me on this! You've already gotten me so much further with the code than...
  8. sarajini

    How to normalize/parse fields? Problem with Instr() syntax

    Hi, Sorry to bother you again... but this code is still giving me a syntax error : ( UPDATE mock_import_table Set Advocate1 = Iif(Instr(1,Advocate,"/"),Left$(Advocate, InStr(1, Advocate, "/") - 1), Advocate) Set Advocate2 =...
  9. sarajini

    How to normalize/parse fields? Problem with Instr() syntax

    Hi Maquis, That code looks good. Unfortunately, Access is still giving me problems with it... Here's what I entered in sql view: UPDATE mock_import_table SET Advocate1 = Left$(Advocate, InStr(1, Advocate, "/") - 1) SET Advocate2 = Right$(Advocate, Len(Advocate)-InStr(1, Advocate...
  10. sarajini

    How to normalize/parse fields? Problem with Instr() syntax

    Hi! I plan to import an Excel spreadsheet that is not normalized. I am wondering how I should go about splitting a field. My Excel sheet has a column for Advocates. A case can have either one or two advocates. If a client has two advocates, they are both listed in the same column. The names...
  11. sarajini

    Autonumber: adding dummy zeroes? starting the #'s at a given #?

    No problem with the above code... IT WORKS!!!! Woohoo! Foolio is a god! gratefully, sarajini
  12. sarajini

    Autonumber: adding dummy zeroes? starting the #'s at a given #?

    Hi Foolio, Thanks again for helping out!!! I'm glad that my posts aren't too unintelligible ;) The union statement hasn’t given me any trouble so far. I am having problems with the SQL though; I don't know if I used the Nz() function correctly. I ended up with a new field with the nulls...
  13. sarajini

    Eliminate vertically repeating records in a select query?

    Hi, I am trying to put together a query with many layers. ClientInfo (containing client name and ID) is the master table, which is connected (by “ClientID” to two child tables: Cases and BriefServices. “Cases” has two child tables of its own: Advocates and Problems. I wrote a query that...
  14. sarajini

    Autonumber: adding dummy zeroes? starting the #'s at a given #?

    Hi Foolio, Wow—those steps work pretty well. (I made a mock “import” table to try them out on.) After step 13 (add autonumber), I made a query out of a) the import table and b) the autonumber field I created. I linked the “firstname” and “lastname” fields. Each client had the same unique...
  15. sarajini

    Autonumber: adding dummy zeroes? starting the #'s at a given #?

    Hi Foolio, Thanks for the 6-digit tip. Whew, that was easy. The rest of what I have to do isn’t so easy : ( I work in a (very nice public-interest) law firm. We have a huge bunch of clients. Among themselves the clients have 9000 cases and 13,000 brief services. All the client records are in...
  16. sarajini

    Autonumber: adding dummy zeroes? starting the #'s at a given #?

    Hi, I have a huge stack of records that I’d like to give ID’s by autonumbers. Is there any way I can tell Access to make the autonumber have six digits? I think the best way to do this would be through adding dummy zeroes. (The first record should have the autonumber 000001; the 3600th record...
  17. sarajini

    Cutting and pasting columns between tables?

    Hi, really simple question...I have a field of information in one table, and I’d like to cut it out of that table and paste it in a different table. What’s the easiest way to do this? Thanks, sarajini
  18. sarajini

    Getting rid of duplicate fields in a select query?

    Hi Leslie! Thanks for giving me that code. Unfortunately, there seems to be a problem... when I try clicking out of SQL mode, I get the following dialog box: Syntax error (missing operator) in query expression 'CLIENTINFO.CLIENTID = CASES.CLIENTID INNER JOIN BRIEFSERVICE ON CLIENTINFO.CLIENTID...
  19. sarajini

    Getting rid of duplicate fields in a select query?

    Hmmm… I think the query is not coming out the way it should. I set the query to unique values only, but the query still displays the three fields for client id’s. I’m sorry, I don’t understand…how should I use the query to create the one-to-many relationships? Should I go into relationships and...
  20. sarajini

    Getting rid of duplicate fields in a select query?

    Hi, I have one table for info on clients (primary key=ClientID). It is connected to a query for clients’ cases, and a table for clients’ brief services. (Each includes a ClientID field.) I wrote a query to display all the fields; I told the design grid to show ClientInfo.*, Cases.*, and...

Part and Inventory Search

Back
Top