Search results for query: *

Wow! Like you said, I am starting to get it..... Okay, So now I have my query, displaying only the open invoices (I used me Apply to No field since that is the same for invoices and checks dealing with one invoice- thereby only showing me invoices that have no payments or credits against...

GREAT!!! Finally got it!!! Thank you so much! I think i figured out why it was not working before, and that is because for ease of explanation, I left out the fact that I had several other Columns in my query (Invoice/Payment Date, Invoice/Check Number etc...) Now I realize I did not need...

When I do this, my query does not change. I still get the same list, with 4 records that should be getting added together to equal 0, but they are not. I keep getting Customer SubTotal 5 103.00 5 (103.00) 5 257.00 5 (257.00) I do not get...

I am probably just not quite understanding this (I apologize - this is one of my first times working with Access and the help and documentation are dismal), but.... I have a subtotal field now, but all I get is the same thing I had before... Amount 1 Amount 2 Total 100.00 3.00...

OKay, I actually got an Idea from what you were asking about, and went to check the ODBC drivers that CR has access too, and noticed on the ODBC setup for Crystal that there is a button that says "Drivers" on it. I clicked it and noticed no drivers loaded. Apparently, this is a...

My problem is, that I need to test the SUM of Amount 1 and 2 over all 4 records for each customer... i.e. Amount 1 Amount 2 Total 100.00 3.00 103.00 103.00- 0.00 103.00- 250.00 7.00 257.00 200.00- 57.00-...

I have a report created in Access. The fields available and being used are Customer # (A), Document Date (B), Amount 1 (C), Amount 2 (D), Total of 1 & 2 (E). I have created a report that gives me a subtotal of each Customer as well as a final grand total of all the customers, thereby giving me...

Pervasive SQL Came with an ODBC Driver (Pervaisive Software ODBC-32). This is the one that I have set up and working correcly with Access and Excel. But CR doesn't seem to like it. When I enter CR, I select New, Custom, Then Data File. This gets me the farthest. I get to choose which data...

I am using Crystal Reports V 5.0.0.108 in conjunction with Macola V 7.5. Macola used to use Btrieve and now uses Pervaisive SQL. My problem is in creating new reports. Crystal no longer seems to be able to read the table names correctly from the file - "file.ddf". When I select...