Solved report not like query (1 Viewer)

mhakim

Member
Local time
Today, 21:50
Joined
Jan 25, 2021
Messages
72
i have query like PIC

and report is not getting the same data

2 yello rows in Query

result in 1 yello row in report
 

Attachments

  • Report.PNG
    Report.PNG
    17.1 KB · Views: 102
  • Query.PNG
    Query.PNG
    24.1 KB · Views: 111

mhakim

Member
Local time
Today, 21:50
Joined
Jan 25, 2021
Messages
72
make the query the record source of the report, u can use report wizard.

i am already doing this

but may be there is a default option in report doesnot show dublicate YELLOW data in rows as PIC
 

oleronesoftwares

Passionate Learner
Local time
Today, 11:50
Joined
Sep 22, 2014
Messages
1,159
Check the group section and while creating the report it is likely you chose summary instead of details.

Re create the report and choose details instead of summary, just after the grouping options in the report wizard
 

Users who are viewing this thread

Top Bottom