Search results for query: *

Hi All! I have been given an assignment by local church to create a small database application to to track and report daily clinic visit information. I have design the tables to capture visit information of patients. But I am having problems with the designing of the database to include clinic...

Hi All Can someone refer to me a article or any website that teaches Multiple Sub Forms in a main form. I have couple of books, but they only give example on simple Parent/Child form. Let me give you my scenario. I would like to create a form that will use a combo box to select the patients...

Hi All! I need help in design of a database table. I have a Sales with the sales information coming from different sources. I need to priortize the output in my query to what I define in the table. Let me explain this via table structure. Lets say I have a source Sales Table as below...

Hi All! I have a table in below format: Dept_ID Expenses Date ACCTING 12000000 6/30/2000 ACCTING 10000000 7/31/2000 ACCTING 20000000 8/31/2000 ACCTING 30000000 9/30/2000 ACCTING 50000000 10/31/2000 ACCTING 60000000 11/30/2000 ACCTING 70000000 12/31/2000 ACCTING 10000000...

Hi All! I have a table in below format: Dept_ID Expenses Date ACCTING 12000000 6/30/2000 ACCTING 10000000 7/31/2000 ACCTING 20000000 8/31/2000 ACCTING 30000000 9/30/2000 ACCTING 50000000 10/31/2000 ACCTING 60000000 11/30/2000 ACCTING 70000000 12/31/2000 ACCTING 10000000...

Hi All I am seeking help to edit my code that finds the word "Status" in a MS Word file controlling from Excel. Once it finds word "status" by itself in the word document, it copies the rest of page and paste it to excel. I have successfully written the code, but my find does not go to next...

Hi All I had been trying to copy text from MS Word file into an Excel spreadsheet. I want to loop through each page of MS Word file and find a word "STATUS". I want to copy the text after the STATUS to the end of the page to excel cell. How can I do this via VBA? I started off with the code...

Hi All I am trying to compute peridic financial returns such as Three Months, Year To Date, One Year, Three Year, Five Year and Ten Year returns from one month period return. Does anyone knows/has a utility or function to do this periodic computation? Feel free to give me the link of a website...

Hi All I am having a problem importing a text file into Excel that has either +avg or -avg as value. When MS Excel opens the text file with +avg or -avg as value, it places "#NAME?" error and try to convert the values to a formula (=-avg or =+avg). Is there any way of preventing Excel to...

Hi All I am kind of stuck on this simple query that I need to create. I have written a function for this, but I get an error. I am wandering if I can get the results without writing a function. Below is the data and I need to find Max_Score for each row via SQL Company_ID Score1 Score2...

Hi All I could not find much information on the web in terms of Excel generating XML and schema from a workbook. I know that Excel 2003 does create a XML and schema for any given workbook/worksheets, but my question is that how can you create XML that you define? How can you create your own...

Hi All I have a table/query (average of dept salary by year) with below data: DEPT Y1 Y2 Y3 Y4 Y5 ACCT 5 6 ACCT 5 6 7 8 9 ACCT 5 6 7 8 ACCT ACCT 5 6 7 FIN 9 8 7 6 FIN 9 8 FIN FIN 9 I would like to get the results in which maximum of periods are...

Hi All How would I delete first two rows of the text file and save text file with other name. For example, I have a text file test1.txt located in C:\Temp\ with below text Cusip Description1 Net Return 12533 Fund 1 .0526 12453 Fund 2...

Hi All I am stuck on the designing a table that would allow a customized grouping. For instance, I have an Employee Table below: Emp_ID Emp_Name Emp_Loc Emp_Loc_Continent 100000 Jack Texas North America 100001 Mary Arizona North America 100008...

Hi All I have a table as below: Dept_ID Salary Original Modified ACCT 5000 Y N ACCT 5000 N Y MKTG 7500 Y N MKTG 8000 N Y I need to get the result from the table in which if there is a...

Hi All I have a table as below: Dept_ID Salary Original Modified ACCT 5000 Y N ACCT 5000 N Y MKTG 7500 Y N MKTG 8000 N Y I need to get the result from the table in which if there is a...

Hi All I would like to know how to dynamically update a field declared in ADO recordset? Let me explain what I am trying to do. I have a few tables in my database that has Date_Created field. I would like to update Date_Created Field in all tables dynamically. I have written the code to do...

Hi All I have a table that records employee salary. First time when someone loads the data, the Original field is marked "Y" and Modified field is marked "N". If that particular employee record is updated, the original field is update "N" and Modified field is...

Hi All I have a table that has following records: Dept Value ACCT 10 ACCT 20 ACCT 40 MKTG 50 MKTG 10 R&D 20 R&D 5 I need my output to be in group by Dept and instead of SUM I need to use product as my aggregate. In other words, my output...

Hi All I need assistance in designing the database that contains multiple parent to child relationship (Hiearchical). I would like store Employee information with multiple reporting structure. The structure of the organization is as follow: Supervisor (On the highest Level), Manager (On the...