Search results for query: *

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

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, 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 posted this in the VBA forum but have been pointed to this one so hopefully someone can help me. I'm producing a duplex report in Access 2003, on the reverse page are diary comments which sometimes go over one page, this throws what should be the front page onto the back page. The diary...

Hi, I'm producing a duplex report in Access 2003, on the reverse page are diary comments which sometimes go over one page, this throws what should be the front page onto the back page. The diary comments are inserted via a sub-report. In the main report I'm trying to create a conditional page...

Hi, I am populating a table via SQL which is run as part of a DTS on SQL Server 2000. This has been running fine until now. the SQL has started omitting to populate some fields, if I run it as a seperate task from the DTS or via Query Analyser it runs correctly so I don't think there is...

Hi, I've written a report in Access on and ADP database which draws data from SQL Server. The report details information on 1 page and then on the reverse (I have setup double sided) details comments drawn from a diary table. Comments vary in length and some go over two pages. My problem is...

Hi, I am writing an Access report that needs to be double sided, on one side information relating to property development schemes (one page per scheme), all this information comes from one table. On the reverse side information relating to diary notes for each scheme (again one page per scheme...

Hi, I am trying to insert data from many tables into a single table for reporting in Access and I have a situation where I have a scheme (this is a property development scheme) that may have more than one 'site', in other words many records with the same scheme but different site. I need to...

Hi, I am trying to update a table from two other tables and I am having trouble with the second sum where the total produced is null, it makes the total for the field concerned (april_actual) null even though the first part of the sum has inserted a value. I've tried using the isnull command...

Hi, I'm trying to write a sql script for sql server that searches a table column for a char and replaces it with either null or space. I can only find how to do this if the char is in a known position and unfortunately it will not always be. Any advice (explained as simply as possible!), would...