Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

Thanks

share|improve this question
add comment

2 Answers

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.

Create-a-simple-report

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
add comment

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
add comment

Your Answer

 
discard

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.