Link to home
Start Free TrialLog in
Avatar of Peter Chan
Peter ChanFlag for Hong Kong

asked on

See the relevant query

Hi,
where to see the relevant query inside Access 2007 report? how to see its query? Thanks.
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

go to the design of the report, select the Property Sheet, Data section and check the Control Source property, it shows where the data comes from. it may be a table or view as well as some query
Avatar of Peter Chan

ASKER

Do you mean record source below? But I see there is nothing within that.
t833.png
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial