Record Source of REPORT other than Query

[mikejaytlabustro]

Greetings!

Everytime i make a report in Access, first thing i do is build a query and then use it as a record source. I try the other way, I go to create report design directly and do the drag and drop of fields. My question is, which of the two methods is ideal? - Thank You -

 

[plog]

Short answer: Query then report.

Long answer: Think about the report you want, build the query to supply that data, then build the report based on that query. Then usually you have to go back to the query to tweak a few things or add a different field you forgot. Then back to the report for finishing touches.

 

[mikejaytlabustro]

Very well explained Thank you.