Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jfirestone
- Order by date
-
Access Report Sum Filtering Help
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...- jfirestone
- Post #11
- Forum: Microsoft: Access Reports
-
Access Report Sum Filtering Help
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...- jfirestone
- Post #9
- Forum: Microsoft: Access Reports
-
Access Report Sum Filtering Help
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...- jfirestone
- Post #7
- Forum: Microsoft: Access Reports
-
Access Report Sum Filtering Help
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...- jfirestone
- Post #5
- Forum: Microsoft: Access Reports
-
Crystal 5 and Macola 7.5
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...- jfirestone
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Access Report Sum Filtering Help
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-...- jfirestone
- Post #3
- Forum: Microsoft: Access Reports
-
Access Report Sum Filtering Help
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...- jfirestone
- Thread
- Replies: 11
- Forum: Microsoft: Access Reports
-
Crystal 5 and Macola 7.5
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...- jfirestone
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Crystal 5 and Macola 7.5
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...- jfirestone
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
