Search results for query: *

Hi, I have written a macro (which is stored in an individual workbook) which runs correctly when using the "Tools/Macro/Macros/Run" tool-bar, however I want to assign this code to a command button. When I do this however I get an error message: "Run Time Error 1004. Select...

Thanks for that, however, I am clearly doing something rather stupid!! This is the code I have written, using your example: UPDATE BCE_Functions_TEST SET fun_name=UCase(fun_name); But I am getting an error message when I attempt to run this: "Function isn't available in expression in...

I want to change the data in a particular field from LOWER or PROPER case to UPPER. Whilst I know how to do this in Excel, I am at a loss as to how to convert/update this data in SQL! Thank you! :-)

Sorry, neither of the above!!! I have inherited both db's, and we are currently using the older (inefficient) set of tables. However we need to be able to compare the data that has been uploaded from Sybase into the new table format. For this I need to take (even a temporary) recordset, that...

Help!! I need to denormalise a new table in order to match it to a table from an old database, in order to validate the new data. I currently have a list of "function id's" associated with both a series of "Products" (up to 3) and "Risks" (up to 4, plus a...

Sorry - Light bulb has just come on!!!! Put it down to a bad day!!!:-)

I think you can tell how confused I have become by the ambiguous title - I don't even know what to call this question!! I need to create multiple rows (from existing rows) in a new table based upon an old table with the following structure: f_id business_function business_function_desc...

Mike, Brilliant - works like a charm!![medal] Thanks for your help Victoria

I wonder if anyone knows if it is possible to use the SELECT DISTINCT clause in a nested/sub query. I currently run the following query as two stand-alone append queries (1 to SELECT DISTINCT the records and the 2nd one to COUNT the records), but would like to run it as 1 nested query. I have...