Kamis, 22 Oktober 2015

Re: [MS_AccessPros] Right join duplicate rows

 

Thank you, John.
I got rid of the group by. The query is the record source for the report.

I have my report set to group Projects.[Project Number]
Then sort by Projects.Rec (a yes/no field)
Then group by [Needs and Recommendations].ID

(Sorry for the spaces in object names; I know better now...)

However, the report is not sorting per the sort instruction and it still has the duplicate records printing repeatedly, rather than grouping them. I am not receiving any error messages.

Kacy

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar