Search results for query: *

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

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

Hi, I have a table of old records and a table of new records. They have identical fields (same number of fields, same names for the fields, same types of values). I want to display them in the same datasheet view, listing each field only once. Old records (1-100) should be listed _above_ new...

Hi All, I'd like to run a query on records with both open dates and close dates. (I would appreciate any tips you could give me!!!!) The query should spit back all the cases that were “open” during certain time periods. For example, the query would show cases open during May '03. 1) The...