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...
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?
Today an Access97 database (with links to SQLServer tables) suddenly corrupted. The trouble appeared when a macro was run and the error complained that a table was locked. Access97 was closed and started after it was determined no other users were accessing the database.
The same error...
I am trying to write a report that needs to join two columns in one table to one column in another table.
In the first table there are two columns: cust_no which is '123' and sequence which is '1'
Someone decided to join our cust_no and sequence number as file_no like this in our second table...
Well, I get the same results whether I use the IIf statement on the zipcode or not. In other words, if I don't put the sale identifier in the criteria box of the query, the query "thinks" the zipcode is null. If I put the sale identifier in the criteria box, I will only get the one...
I have a query that is joining four tables. The first two tables join on a sale identifier (text), the second and third table join on a customer number (number) and the third and fourth table join on the customer number to get a zip code.
Some of the zips are null so I supplied this code to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.