Recent content by CarolCook

Also, I will need to create reports that bring in any document with all its values but only for one salesman.

Thanks for answering Pete: The problem is that the foreign key value is a memo field. This is to accommodate other types of info such FieldValue = date or some other hard coded value. What I wound up doing was to create a formula which converted the memo to a number for salesman and created a...

Hi: This is the SQL data table I am using for my report with a couple of sample rows. Document Field Name FieldValue (memo) Salesorder Salesman 1 Check Salesman 24 Many different document types, many field names, many identifiers. The...

Answered my own question - have to do through Control Panel.

Any ideas on how to proceed? SQL Express does not have the Utility Explorer and uninstall/remove programs is no more. Thanks in advance.

Hi: It must be something with that specific field because when I added another field, it worked perfectly. It may be that the field I was grabbing was a BLOB and MSQUERY didn't like it. Using File>Return date to Excel gives me all kinds of formatting that I can't use. I think I'm all set now...

I am using Connections, Property, Definition to edit my SQL query and saving. Then I use Refresh.

Yes - pulling from Pervasive SQL. By extreme right hand side of the table, I assume you are not talking about the spreadsheet but the table itself. No column, no column heading, no values. Thanks for your quick response!

Using Excel 2007 and a fairly straightforward query which pulls data from ODBC. I have edited the query to add a new field but regardless of where I put it, I don't get a new column on the worksheet with the new values. If I use the query editor, it does show data but this is an already heavily...

Using Excel 2007 and a fairly straightforward query which pulls data from ODBC. I have edited the query to add a new field but regardless of where I put it, I don't get a new column on the worksheet with the new values. If I use the query editor, it does show data but this is an already...

Unfortunately, I needed the results to grid so that they could go to Excel. I wound up just using my query in a Crystal Reports command line which gave me the two line Excel output. Thanks!

I need a single query to produce output on two lines. The output needs to be copied into Excel with headers. I tried inserting char(13) and char(10) but that does not make the output break. Any help is appreciated. Thanks

The XPS Document Writer worked perfectly. Thanks!

Yes, I did follow that procedure. Windows 7 64-bit. Thanks!

Yes, I did try that but was still not successful in seeing the custom form. Custom forms are tied to the O/S as opposed to a specific printer so I am even more puzzled.