Search results for query: *

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

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

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

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

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

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

Hello, I've had great help from you (plural) here in the past and hope there's a guru out there who can shed some light on this perplexing problem. We run a very important process at each month end that requires an Access table to be updated with an update query. It has been working for...

I'm using Access 2000 that is linked to SQLServer6.5 tables. I was able to create queries until suddenly I started getting "Invalid Argument" whenever I tried to save. The help button produced a blank help screen. I have tried repairing the database and restoring the software, but...

I have a target table that has rows grouped by two columns, customer and order for the sake of argument. Customers can have many rows with the same order number. For each group of customers, I need to update the first row of a unique customer_number and order_number with a possible max and...

I've been trying to get a macro to run a series of query scripts and functions. When I do the steps by hand, everything runs fine. However, I have one function that seems to go on forever when it's run from the macro. Do I need to put some memory clearing code at the end of functions? I've...

I have set up a macro that runs quite a few queries and functions. The functions also call queries. Many of the queries need a user to enter the start date and end date. What I want to do is be able to let the user enter the start and end dates once, walk away, and find the finished process...

We have an Access97 query that will return data just fine as long as the dates are not in 2001. We use a start date parameter and an end date parameter entered by the user. The query uses 7 tables that are linked to a SQL Server6.5 database. Whenever we use a date that is in 2001, we get an...

Is there a way to get a verticle line on an Access Report that will cross the groups? Or do I really have to put a verticle line in each group and line them up? I know I can use the format "left" "width" "height" values but every time I change spacing for the...

I know Access 97 databases have a one gig size limit. Is there a limit for individual tables as well? I'm asking here because you all are usually lightning fast, and I'm not sure where to look in the documentation. Thanks for any help! Ken

My Acces Report has month, year and office totals. I don't want any of the totals to be the first row of any new page. In fact, it would look much better if any of the total rows is going to appear at the top of the page, that 5 to 10 detail rows appear first. Is there a setting in headers or...

I'm trying to get the right running total in an Access Report. The report runs off a select query which includes City, Date, Account_Entry. In my report I have Sorting and Grouping this way: City Group Header Yes Group Footer Yes Group On Each value Date Group Header Yes Group Footer...

I've been asked to "fix" someone else's query which I thought was going to be simple, and may yet be, but I'm stuck. I don't have the code in front of me to work at this moment, but I know the problem. The query selects columns grouped by File_number, dates, and sums the money column...