Recent content by KHerm

I seem to have found the answer myself. In my query I am using this construct in the field: StrComp([table1].[column1],[table2].[column2],0) In the 'critia' I put 0 and in the 'or' I put Is Null I think that got it!

I've searched this site and the web with the subject as the search criteria, and I'm not finding a way to do case sensitive joins in Access. I came close with StrComp but I can't do outer joins that way. Is it possible to do case sensitive joins in Access in conjunction with an outer join...

LB, what you suggested is great, and I'm almost there. I have been able to get the across display I need. However, the data is all in one variable and is comma separated, as the coding is set up. Is there a way to get each value in it's own variable? I've already got a routine to grab the...

I see my scenario forgot one important fact. There are muliple rows per person for the award amounts (award1, award2, award3). I can't figure out how to get the list of awards to be listed in column arrangement rather than in rows. KH

I don't know if this can be done in Crystal Reports 8 or not. A request has been made for a report to appear with both details and sums in one row. This is for a financial aid report where it is important to know individual monetary award amounts and starting and remaining financial needs...

One more question. If I need to have a sort within a sort (first last name then city, or city then last name) how would that be set up? KH

Thank you very much for your quick and "worked the first time" answer! So easy, really, but I don't think I could have found that solution without a lot of frustrating work. Much appreciated! KH

In Crystal Reports 8 and 8.5, is it possible, when the user runs the report, to be able to select different columns to sort? I do know how to allow users to enter values to sort on, but it would be nice to be able to let them sort on name one time, or say, city another time. Thanks!

I have now run across several Windows 2000 Pro workstations (even in different States) where the administrator is not able to write to folders (this has happened while trying to copy files and while trying to install applications). In two instances the operating system was installed again and...

I'm stuck with Access97 at this location. I'm dealing with over 500,000 rows in the SQLServer (version 7) table and I'm trying to create a working Access table from it to run some reports. My other queries are not super fast, but they definately aren't as slow as the way I've joined them. I'm...

I've run into a problem joining with dates. I'm linking an Access table with a linked SQLServer table in Access. I have a date in each table that looks like: 10/10/2000 12:15:25PM. The join works if I put the following in the criteria field...

Also just for the record: I forgot to mention above that I also tried to repair through ODBC which also failed. Thanks VBSlammer for that last try, but it didn't work either. Glad we had a backup! Ken

I'm needing to import excel spreadsheets into Access97. I have found a way to do it, but now I want a form to find the file I want to import. Would I need some kind of drop down box in the form? Right now I have most of the path name for the file in a module and I pass in the specific file...

As always, this forum has great help. Thank you both. Unfortunately the database could not be recovered with any of the methods you gave or I found. Just for the record, I'll recount what I did. 1. Found an archive here with a link to a commercial software that repairs access databases...

Paddyo, your suggestion sounds intriguing, but when I went to my ODBC setup, I couldn't figure out what to do to start a repair. GeekGirlau, we downloaded jetcomp.exe, but it doesn't seem to do any repairing, just compacting. Do you have any experience you can share?