Search results for query: *

Yes - the query has grouping. The underlying data is by Sales person and item and region. The query then groups by item and region - summing up all the sales person's revenues. The other computer runs the query fine (the same) with HAVING or WHERE as the filtering clause.

Thanks for all the tips guys. I did repair & re-install Office 2000. That didn't fix the problem, but I didn't completely remove Office and then re-install. There are not multiple versions installed. Like I said - I tried HAVING and WHERE. As I understand it, the queries will run in...

if I use like instead of =, the query works correctly. My first theory was the same as yours - that the "NE" field may contain more data than the NE that is displayed, therefore it filters differently. But adding a second, random criteria wouldn't seem to fix that possible problem...

I think I uncovered a bug in Access version 9.0.2720 installed on one of my two computers. If I change the filter in the query to filter for more than one thing, regardless of what the second thing is, then it seems to work. So the query basically was Select SalesPerson, Region, Item...

I open two copies of the same exact database on two different computers. The tables and queries are identical. There are two nested queries. The first query merges two large tables - a 1st half 2001 and a 2nd half of 2001 with data by month. It merges them by first finding all possible key...

I have a report set up using record selection, and it can query for one customer at a time based on 2 parameter values: the customer name and the sales person. The customer could be a buyer or seller so my record selection has an OR statement: ( ({Orders.buyer}={?Cust} and...

It worked perfectly! Thanks so much rhinok!

Still hoping for an answer to this. Actually, now I'm changing the reports from 0501 to 0601. It isn't too tedious to change from one month to the next, but seems like there should be an easier way... Thanks in advance.

I've got a report that uses 2 tables, one of them twice. They are linked, with multiple selection formulas, formulas, graphs, etc... Both of the tables end in 0401 for April, and I need to switch them to 0501. Is there a quick way to do this? It seems I have to add the 0501 tables, edit the...

I'm just learning about this myself. I think this will get you pointed in the right direction: Add a new table - add table2 again. It will ask you to give the new table a different name like table2_b Then in the visual linking expert, link table1.ID1 *= table2.ID1 and table1.ID1 *=...

Thank you Malcolm! It works! After a few months of use, I've found Crystal Reports to be a terrific program, and this forum has been VERY useful as I learn more. Thanks to everyone for the posts.

I'm using CR 8.0 I've got three tables: buyers =* orders *= sellers Every order has a buyer or a seller, but not always both. I filter for a certain client - either as a buyer or seller. I need to sort by the client order type, which is located on the buyer or seller table (depending on...

Malcolm W, Thank you, thank you, thank you !!! Either the correct braceting, or the putting IsNull first made it work. FYI - I didn't make too clear before - the query never gave error messages, it just would either exclude all orders without a buyer AND seller, or include all versions of...

I'm having a heck of a time with nested record selection formulas. I've got on 3 linked tables - Buyers =* Orders *= Sellers I need to display all orders which had XYZ as a buyer or seller, and only info from the -1 version of the buyer or seller table. The problem I'm having is: how to...

I've replicated the database, with good success. I can make updates, and syncronize the databases with users still in the replica. Problem seems to be solved. But... In the replica, or the master, I can not delete records from any table. The backend database still works fine, and other...

Thanks for the response Mike. Your solution still requires that all the users shut out of the database, and I am hoping for a solution that doesn't require that. The problem basically is that our users keep their computers always on, with most applications always open. All of my users will be...

I've got one database with all the tables and a database password, and another with queries, forms and reports that is secure with users and groups. I'm about ready to give about 100 people access to the database... and a little nervous to see how it will work. One problem I already forsee is...

I've got a form of firms, with two subforms - contacts (one to many relationship) and mailing lists (one to one relationship).<br> <br> I can filter records on the form, and the subform records are filtered.<br> <br> When I filter using a field in one of the subforms, that subform is filtered...