Search results for query: *

Ok, I've done that for the formulas in my first row - thanks. Now I want the formula to update the cell when I use the fill down option. Currently the cell row and column in the Indirect formula remains fixed.

lbass, I have not had time to fully test this, but so far so good. Thanks very much for your help.

Excel 2003 I have a cell which contains the name of a sheet. Sheet 1 for example. I want my formula to use this cell as it's reference to the sheet I want to extract values from. So therefore if I change the value in the the cell that has the sheet name in it the formula will also change...

I've tried substituting the table names and fields, but when I am then prompted to enter a value to allow the command I get an error message. This is add command... ?pm-TRAINREC.COURSE_REF ...and this is the code I have substituted... Select "EMPLOYEE"."EMPLOY_REF" From...

Thanks for your reply, however I'm a little confused by the query you have written. I should have detailed my tables and fields more clearly when I first posted. Could you interpret the tables and fields below into the query you wrote accordingly, please? Table: COURSE with a field...

I can see what you are both saying, but I have additional issues on top of that. For the linking part my employee table only contains those employees that have taken a course (essentially it is a training record table). I have a third table with all the companies employees in it. How do I get...

Crystal Reports Version 11 I have a table which contains Training Course names (let's call it Table 1) and another table that contains Employees and the courses they have attended (let's call it Table 2). I want to be able to list all the Training Courses (Table 1)followed by a list of...

Crystal Reports Version 11 I have a table which contains Training Course names (let's call it Table 1) and another table that contains Employees and the courses they have attended (let's call it Table 2). I want to be able to list all the Training Courses (Table 1)followed by a list of...

What do you mean by "Another is to select the data and use group suppression.

CR V8.5 I have passed through a value from a sub report to a main report and subsequently divided this value into a another value in my main report using a formula. I now want to do a select on the result of this formula, but Crystal is telling me the "formula cannot be used as it must be...

What if the MS Access database the ODBC would link to does not reside on a network drive they can have access to? And what if I cannot put the database on a drive they have access to?

MS Excel 2000 I have a workbook in Excel with about nine worksheets, all of which have an external data source connection to a MS Access database. I want to be able to share this spreadsheet with other users who may not have the source database or indeed may not even have MS Access. How can I...

Excellent - thanks for that. I have been trying to sort this problem on and off for the past year!

I have a series of three databases which filter out a large amount of data for exception reporting purposes. The databases can be accessed remotely by any of four users. Once the first database is kicked off the other two databases run in series until the reports are produced in an excel format...

Wow - that simple! Thanks

MS Access 97 I thought I could do this easily, but apparently not. I want to be able to remove blanks from fields. for example if I have data as follows: xxx xx yyyyy zzz zz I want to end up with xxxxx yyyyy zzzzz

MS Access 95 I would like to know how I can remove the last two characters from a field using a query. The field is a post code field which sometimes has the post code entered with a space and sometimes without. e.g. NR11 8DD NR118DD For both of these examples I only want to remove the last...

CR v8.5 I want to be able to list employees who have not been on specific training courses. I have a table of records for each training course an employee has been on called Training_Records. It has the following fields.(One row per course so an employee may have more than one row depending...

Ken, That's sorted it. Much appreciated.

OK I have tried the following: Cell C6 contains START DATE Cell D6 contains START TIME Cell C7 contains END DATE Cell D7 contains END TIME These cells can have the data changed at any time depending on what range of dates/time I want to sum. Cell E6 contains =C6+D6 Cell E7 contains =C7+D7 My...