Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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