Creating a report solely from Query

[sellis]

I know this is stupid. I know it has to be. I have read back through the comments, I have read my book, I have looked online, and I cnanot find this simple thing, so I know I am missing something. I have run a query with my new hire employee's names and some dates. I am now trying to put those certain employees that fall into certain perameters (as defined in the query) and only those employees into a report. When I try and create the report, of course it wants me to only use fields. Then when I start manipulating the property sheets and such to try and get to the queries I get #error on my report where the data is supposed to be. I can either get all of my employees from my base table or I can get errors. I cannot figure this out, and I know I am being stupid. Help please.

 

[boblarson]

A report has a record source and that is set as a table or a query. You would set it to be your query and then you would put the fields from the query into the report by binding the controls' control sources to the particular field you want to have it display.

You can add those fields onto the report by dragging and dropping them from the available fields list (make sure they are in the report's record source though).

 

[sellis]

Do you know if it is possible to change a record source once you have already created the report? I have typed in a rather lengthy report, and I would hate to have to redo the whole thing if I could avoid it. Thanks - you have been a huge help to me.

 

[boblarson]

Do you know if it is possible to change a record source once you have already created the report? I have typed in a rather lengthy report, and I would hate to have to redo the whole thing if I could avoid it. Thanks - you have been a huge help to me.

You typed in? What is it that you typed in and where did you type it in? The data for a report normally comes from TABLES which house the data. It isn't typed directly into the objects of a report.

 

[sellis]

The report has a bunch of typed words and then pulls information from a table. It is something we send out to our new hires, so we tell them a bunch of information and then need to pull data from a query to stick into the report. I know that you can pull the information and send it to word for this stuff to, but I am trying to make it so I pretty much just click one thing and Access spits out all of these different reports I have to send to new hires.

 

[boblarson]

Okay, you might need to read over how to use reports in this:
http://www.functionx.com/access2007/Lesson19.htm

but the Report's Record Source should be the table or query for what you are going to display on it. You can add a CONTROL (Text Box) and type words into its CONTROL SOURCE like

="This is something in my control source which I want..."

however I believe it is limited to 255 characters.

Otherwise, if you want a long paragraph, you should create a table with an ID and a memo field for the entry and then you can create a report with just the ID and Memo Field in its record source and you can format it just to have the text there. Then you can place it on the other report as a subreport in the section or header or footer that you need it in. It is a bit difficult to explain it all to you as I don't have time to write an entire tutorial. But hopefully with my explanation there and then the stuff from the link I gave, it might help.