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

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! :-)

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

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

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