Search results for query: *

Thanks everyone for responding. GMMASTROS- I tried inserting your "Select Coalesce" code into a new column in Query Designer and received a "Invalid or Missing Expression" message. Any ideas as to why I would be receiving this? Thanks. Steve

I'm somewhat of a novice with SQL 2000, so please bear with me. I have created a large query in SQL Query Designer. Unfortunately I cannot use CASE statements in this. Essentially I need to all values in column TX_PA_HOMESTEAD.HOMESTEAD_12, that are less than 51 to become 50, and all other...

I'm somewhat of a novice with SQL 2000, so please bear with me. I have created a large query in SQL Query Designer. Unfortunately I cannot use CASE statements in this. Essentially I need to all values in column TX_PA_HOMESTEAD.HOMESTEAD_12, that are less than 51 to become 50, and all other...

That's exactly what I needed! Very easy. -Steve

I am working with a client who uses Microsoft Access 2000 on an XP machine. We have made a Macro for the client that calls upon a detailed query and eventually exports the data to Excel form. How can I have a "combo box", or some other window, automatically open for the client at the beginning...

Hello. I have created a series of Macros in Microsoft Access 2000 that allows a technology-challegenged client to create exports from underlying SQL data. The final process in the macro creates an Excel spreadsheet toa specified folder on their desktop computer. Since I am using Access 2000...

Hi, I have created a series of Macros in Microsoft Access 2000 that allows a technology-challegenged client to create exports from underlying SQL data. The final process in the macro creates an Excel spreadsheet toa specified folder on their desktop computer. Since I am using Access 2000 and...

Turkbear, I think that did the trick! Thanks for the help. -Stevehatpa

I am only a Crystal Reports user, but am attempting to change a past coworkers report. We have a a report that grabs various information, such as name, address, account number, etc and puts it into a report for printing out. There are some of them that put the name and address of someone, even...