Recent content by Minimorgie

Hi, I've worked it all out now! Thanks very much for your help.

Funnily enough I just got it working, but I also need to include the date column next to the note now, this is the formula that I used ...

I've been fiddling around with this for a while and I can't get it to work, obviously I'm doing something wrong, if you could provide an example dataset with this formula I think that would really help. Many thanks.

Thanks for your help, I'll have a bash with your suggestions and let you know if it works out ok.

Hi, I am an inexperienced VB user and I want to do something which may be simple but I can't work out how to do it. Here's the situation. In Excel I have 2 sheets, one called Information and the other called Notes. I want to copy from Notes to Information, I need to match an id from column A...

Hi, Thanks for your help with this. In the end I decided to write everthing to a temp table using the following SQL : insert into rag_temp_notes (schemenoteid, schemeid, notedate, notetypeid, note) select schemenoteid, schemeid, notedate, notetypeid, substring(note,charindex('###', note,4)...

The use of STUFF will not work for me because our SQL version is 2000. What I am trying to achieve is a list of the notes (without the ### etc where it is included in the notes - not always) along with the unique identifier - in this case schemeid. The notes come from the tableschemenotes and...

Hi gmmatros, I have copied your scripts and got the hang of what you mean but when I try it on my live data using the following : Declare @site_info VarChar(1000) Set @site_info = (select distinct cast(note as varchar(500)) from schemenotes) Select SubString(@site_info, CharIndex('###'...

Hi, I've trawled previous threads to see if I can find an answer (that's clear to me!) to my problem but no joy. Anyway, I'm using SQL scripts to extract data from a source database into a reporting database. Some of the data contains text which I need to remove e.g. ### Bronte Rent ### this...

Thanks pwise, I can create a new stored procedure which successfully looks up the tenures in my table. However, I need to get the parameter to list the tenures so that when the user is running the report they can select from a list. How do I incorporate this stored procedure into the...

Hi, I am writing a stored procedure in Access which is connected to a SQL DB. I like to use the design window and have created parameters in the criteria column which require entry of a date range. However, I now need to create one which looksup the possible values from a column in the table...

Hi, After a bit of fiddling around I got this code to work so many thanks for your help. Incidently, I checked out the help and whilst I can see that the basis of your code came from the help script, there's no way I would have been able to work it out. This is only my second ever VB script...

I see what you're saying with the ABS function but that's not really the bit I'm stuck on. I need to know how to write the macro or VBA to search for the values which are less than zero AND have a cost account equal to one of those in my list. If these conditions are met then I need to replace...

Hi, I have columns of financial data and I need to search for a cost code / value combination and where certain conditions are met I need to carry out a replace. Here's some sample data : cost centre cost account Period Balance date 1002111 1100 186000.00...

Hi - I've sorted this out myself, the problem seemed to be with the code being in the detail_print section, I've moved it to the detail_format section and this seems to have sorted out the incorrect pagination and retained the page break in the correct place. Sorry for the unecessary post.