Search results for query: *

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

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

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

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

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

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

Microsoft Excel 2000. I have three columns as below: Date Time Litres I want to be able to sum the litres between a specified date and time range. (This range will be determined by the contents of four more cells containing Start Date, Start Time, End Date and End Time - these cells can...

CR V8.5 I have a report which contains a subreport. The main report has a (very simple) shared value from the sub report in it. Let's call it: @mainformula whileprintingrecords; shared numbervar historycount; historycount I then add this value (above) to another value (@waitinglistsum) that...

How can I get access to show records for the last 6 full months of a date/time field.

If I select the 'Use Server for Speed' option does this impact any formulas that I have set up? For example if I have the formula: left([Field],3) will this be performed by the server or not?

If I select the 'Use Server for Speed' option does this impact any formulas that I have set up? For example if I have the formula: left([Field],3) will this be performed by the server or not?

CR8.5 I have a formula in a subreport which I have pulled through to my main report using the Whileprintingrecords method. Is there any way that I can perform grouping on that formula in the main report?

CR v8.5 I want to be able to link part of a field in one table with the full field in another table. i.e. I have a field which contains Root Cause for various sites: Root Cause SITE1 SITE2 SITE3 I have another field in a different table which contains the details of these sites, but the...

Access v2000 I have a table that contains site assessment details including the date assessed and the assessor: Site 1 Assessor 2 01/02/2005 Site 2 Assessor 1 05/02/2005 Site 3 Assessor 1 03/02/2005 I also have a table that contains future site re-assessment details...

I currently use a traffic light system to score assessments that are entered on MS Access. The assessment results are then exported to MS Word, but lose the colours. Is there any way I can export a report from Access to Word and keep the colour formatting?

CR v8.5 I have a formula ({@Training Days}) that calculates training days based on the number of attendees and the duration of the course. This works fine I also have the report grouped by Trainer Reference and by Course Ref so that I can see the training days for each course that the trainer...

CR v8.5 I want to be able to search for the same parameter in either of two fields. My current formula is: {Support_Incident.Reservation Number Full} = {?Parameter} or {Support_Incident.RA Number} = {?Parameter} This formula behaves strangely: If I am searching for {Reservation Number Full}...