Basic Reports question

[msaunders26]

Hi everyone,

Totally new to Access and have some really simple questions here... thanks in advance for your help.

I'm creating a report in Design View because I want to have detailed access to how it will look. Before starting building this report I made sure I built queries that return tables with all the data I will need. For example, one query only returns a 1x1 table with one value, but some have multiple columns and rows.

What I need is a way to just make some text and then beside it the result(s) of a query. All of this in table form would be a bonus but isn't required.

For simply having text on my report, a text box has two boxes I don't yet understand, and a Label gives me an error about being unassociated.

How can I present plain text and the results of my queries? Am I approaching this in the right way? Thanks!!

 

[liddlem]

Hi Msaunders26
Unfortunately, I think we need a little more detail from you as I do think you are going about the wrong way.

A report should source data from a single table or query. It sounds like you are trying to grab data from more than one source. (Which is why you're getting the error about something being unassociated. Access is asking you how these two bits of information are linked - which is what relational databases are all about.)

I could go into detail about how to accomplish the following tasks, but this forum will probably have many examples with sample data of what you're trying to do.

So first try to get your head around how queries work.

Then use the report WIZARD to help you design your report. Trying to design a report a a novice can be rather difficult.