New to access, please help if you can!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have recently created a form that, when ran, will run a query that pulls
data from my table, and then gives me the information in query view.

My question is: Is there a way to set it so the form still runs the query,
but the information appears in report view? I have tried creating a report
to pull its data from a query, but since I have the query tied to the
aforementioned form, when I open said form, it prompts me for parameter
queries.

I would like to set it so that somehow I can run the same form and have the
information appear in report view instead of query view.

Thanks.
 
I'm not sure I entirely understand what you have there, but ...

If you have a query that returns the data you wish to see, you can:

* start at the database window and click on the <New><Report> toolbar
button
* pick the Report Wizard
* follow the steps, selecting your query as the source of the data for the
report

(and if you don't have the query first, build it first.)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top