Recent content by Deano1976

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