|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
Report Format - 9/14/2005 2:26:32
Hi Everybody:
I am new MS Access person. I encounter a problem. I got the result of the query like this:
Table 1:
Vendor Name Date 1 Paid 1 Date 2 Paid 2 Date 3 Paid 3
Micro ------------1/2/05 $1
Micro -------------------------------2/2/05 $2
Micro -------------------------------1/2/05 $3
Micro -------------------------------------------------2/3/05 $4
Micro ------------1/3/05 $6
DHL -------------1/2/05 $1
DHL --------------------------------2/2/05 $2
DHL --------------------------------1/2/05 $3
DHL --------------------------------------------------2/3/05 $4
DHL --------------1/3/05 $6
.....
So, how can I change like this in MS Access:
Micro 1/2/05 $1 2/2/05 $2 2/3/05 $4
Micro 1/3/05 $6 1/2/05 $3
DHL 1/2/05 $1 2/2/05 $2 2/3/05 $4
DHL 1/3/05 $6 1/2/05 $3
I want to save the space, Please let me know how to do it. Thanks a lot. Thanks.
|
|
|
|
rubyaim
Posts: 757
Joined: 6/22/2005
Status: offline
|
RE: Report Format - 9/14/2005 18:46:56
Hello, I'm not 100% sure what you require, but is it that you want to remove duplicate records? Perhaps you could clarify a little more...
If it is duplicates you want to hide, you can do this via Properties.
From Access Help
quote:
Hide duplicate data in a report
Hide duplicate data on a report with only sorted records
Open a sorted report that might contain duplicate values in Design view.
Select the text box that might contain duplicate data and click Properties on the toolbar.
Set the HideDuplicates property to Yes.
In a text box for which HideDuplicates is set to Yes, Microsoft Access prints a value in the first record in which that value occurs and, if records with the duplicate value continue onto another page, at the top of a new page.
Hide duplicate data on a report with grouped records
Open a grouped report that might contain duplicate values in Design view.
Move the text box for the field you're grouping on from the group header to the detail section.
Select the text box and click Properties on the toolbar.
Set the HideDuplicates property to Yes.
Remove lines and all other controls from the group header.
Double-click the section selector of the group header to display its property sheet.
Set the Height property of the group header to 0.
The group name will appear only at the beginning of a new group or at the top of a new page if the group continues for more than one page.
If this is not what you want, do you think a Union Query would get the results you are after?
Another option would be to join your fields in the query (maybe you want to combine the Date and Paid fields?).
_____________________________
Sally
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
