up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
57% accept rate
feedback

1 Answer

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

link|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. – AlwaysLearning Jun 14 '11 at 20:16
feedback

Your Answer

 
or
required, but never shown
discard

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