Access 2007 Question

[Atomic]

I have various tables, queries, macros and want to be able to create a report in Access.

I can obviously create the report using 'Report Wizard' and be given options to use Table or Query fields. I want to use query fields as my report will be using queried data. However, I'd rather start a report from scratch, but can only see a 'Add Existing Fields' button relating to fields in tables in the Access ribbon. There's nothing there about adding fields that are coming from a query.

Can I input Query fields into a report not using the report wizard.

Thanks for assistance.

 

[~J~]

I'm not sure I understand what you mean.

If I use Access2007, and goto "Create", the ribbon changes to what options I can create, one of which is Blank Report.

Once I do that, I can drag columns from the tables on the left.

Or am I missing something?