Recent content by suzey

Has anyone found a limitation to the number of levels allowed using the group and outline facility in Excel 2003. I have got to level 8 and cannot create any more levels, but do not get any error messages. Thanks Sue

Thanks sdempsey, I don't think the datediff function will help as I need to know for multiple weeks if the item was active in that week, even though it could be completed in the current week. Sue

I am a complete novice in SQL (2000) and wonder if someone could offer some guidance. I would like to create a view or procedure, or something else, not sure what is best that would find out the status for each item at a particular point in the year ie: during week 24, how many items were...

Dear Synapsevampire, Sorry for the lack of detail, frustration had set in!! I am using Crystal 8, and connecting to data on an SQL server. What I'd like to do is find out the status for each item at a particular point ie: during week 24, how many items were complete, active, rejected...

Dear All, I would like to be able to count an item to see how many were open items within a particular week. So, I have a start date and a finish date for each item, and I want to count the items for each week that falls between these two dates. I have the following (which I copied from the...

Thanks lbass, that worked ......I had it stuck in my mind that it had to be a number to get the chart to display them in the right order. Thanks again Sue

Thanks lbass, I was hoping to do this all in a formula, 'cos I want to use this field in a graph. At the minute if I format the field using the formatting options it is not carried onto the graph, and I've searched through all the graph options and cannot find anywhere to format the number...

Hi Everyone, I want to display the week number, which is no problem, I can get the week number using the datepart formula. But this returns a number with decimals ie: 34.00 Is there a way to make this formula just the whole number? I've tried various functions, fix, truncate, round with no...

Gary, The report is basically order details,ie : order no, specification, nothing fancy really. The subreport, looks at the history of the order, and brings back a date based on certain criteria. I did try putting it all in the report instead of a subreport, but the tables are too large, and...

Hi Everyone, I hope someone can help. I have a small report, that I use to export data. On the report I have had to put a subreport to bring back one field. I had already tried to do it in the report, but it takes too long to run. So, the subreport gets some data, then I bring that data...

Hi Everyone, I have a form with a continuous subform on it. I want the user to select the data in the subform based on the data shown on the main form - they have to do this, as it is a manual matching facility. At the minute, on the subform I have disabled the scrollbars, so they have to use...

Thanks Stephen, Unfortunately, this database is inherited/externally owned and created and I don't really want to change the design of any of the forms/documents, as this may be affected if the external company make changes in the future. I am therefore creating new views. Any other...

Hi All, I have a column in a view that I would like to do a DBLookup to another view in the same database, based on another field in the view In the help files, it says : 'This function does not work in column or selection formulas, or in mail agents.' I am a bit of a novice at development...

Geoff, Yep, I've tried with the file open and closed, no difference. I think I'll be putting this one down as a 'not possible' for now, but thanks for all your help. Sue

Thanks again Geoff, Unfortunately I still cannot get this to work, have I missed something. In cell C1, I have the following typed in : d:\temp\thefilename.xls then in the formula I have : =INDIRECT("'[" & C1 &"]Sheet1'!$H$6") I've also tried just putting the...