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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding 'true' duplicate rows in access table
pwise: Thanks for your quick response. However, I am not getting the desired result. I am getting a lot of entries with Expr1 = -0. Could you please elaborate on what should I do to sort this out. JoeAtWork: Thanks - I alrady have more fields in the table but I didn't want to overload you guys...- rmuzam
- Post #4
- Forum: Microsoft: Access Other topics
-
Finding 'true' duplicate rows in access table
Hi, I need help in finding 'true' duplicates. I am trying to find duplicate payments in 'Payments' table. Sample 'VednorNo' and 'Amount' field entries: A 100 B 50 A -100 A 100 C 40 B 50 Running simple duplicate query from access will report duplicates on amount 100 and 50. But...- rmuzam
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
-
MDX Query Help-- Calculate running total
Hello I have a Fact table in my Warehouse database containing data since 2001 till today. This table is a source table for a Cube also. In this cube, I want to creata a "Calculated measure" displaying running-total of the "Quantity" field starting Jan 01, 2003 till today. For dates before Jan...- rmuzam
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
