Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Where is my Query??? I'm using Access 2007, until this version I would create a query then create a report based in that query, using create-blank report. If I use the report wizard it does give me the option to use the query, but when I use the wizard the report is had to edit the design. Could someone please tell me how to create a report (from Blank Report) using my query?


share|improve this question
up vote 1 down vote accepted

When you add a control to the report go Property Sheet, Data, Control Source and choose the Query information you need. The link is to the Microsoft page on the subject I hope this helps.


share|improve this answer
Your comment showed me this: I can create a Blank Report. then open poperty sheet and pick my query. But, now when I click Add Existing Fields, it does not show the fields from my query. It just shows me all the tables. So I suppose I need to pick my fields from the tables.. I think this stinks.. Why would Microsoft change this - why can't the query fields be available so I know exactally what I am puling out of my query... – LtDan Jun 14 '11 at 20:14
I do agree, but unless you can use the wizard this is the way I have to do. I have found the wizard is a good starting place and the edit the report or form from there. – N4TKD Jun 14 '11 at 20:16

You CAN make a blank report than add fields from a query like this:

  1. Create a blank report;
  2. Go to Property Sheet;
  3. Choose "Data", select "Record Source" and choose your querry;
  4. Save your report;
  5. Open report in Design View;
  6. Select "Add Existing Fields";
  7. In the bottom of the Field List select option "Show only fields in the current record source";
  8. Voilà.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.