I am having issues on my report. My Data structure looks like this
Shipment Received
Date Date Price
Product 1 1/1/2007 2/1/2007 $1000
Product 2 1/5/2007 2/9/2007 $2000
Product 2 1/10/2007 $2500
The report that I want is just like a monthly calendar. Example
January February
1 -$1000-Shipped 1- $1000- Received
2 2
3 3
4 4
5- $2000-Shipped 5
6 6
7 7
8 8
9 9- $2000-Received
10-$2000-shippned 10
I created a Union Query for this. However when I ran the report I got a duplicate records for the day number. It shows like
January February
1 -$1000-Shipped 1$1000- Received
1- 1-
2 2
3 3
4 4
5- $2000-Shipped 5
5- 6
6 7
7 8
8 9-$2000-Received
9 9-
10-$2000-shippned 10
10-
How do I get rid of the duplicate item?