In a report is there anyway to include a field in a label.

e.g.
For [Hours] worth of treatment hours of at [RatePerHour] per hour.

Instead of having to do it
Label: For Text box: [Hours]...etc which will lead to the spacings being oddly distributed.



Also how to do I get a list of queries on a report instead of the queries being spread out per page.

e.g.
Date: Duration: Cost:

02/11/2009 30 £25
04/11/2009 40 £35


Thanks in advance for your time and I hope that makes sense.

Just change the label to a text box and format it like a label and then you can just set the control source to be:


="For " & [Hours] & "worth of treatment hours of at " & [RatePerHour] & " per hour."

Brilliant thanks boblarson.

Any idea with the second problem?

Not quite understanding what you are experiencing with the second issue. Can you upload a screenshot? (upload - don't post to imageshack or photo bucket, etc. as I can't see those at work).

Have uploaded, don't know if it will make it any clearer.

Basically I have want the 3 appointments listed on the same invoice, so they appear under each other.
Instead they are separated into page 1,2,3. I'm sure it's not complicated I just haven't got much experience hence why I'm so useless.

I'm not sure if that description helped either.:p

One more screenshot, if possible. One of the report in design view. I think you may either have the sizing wrong or perhaps a setting wrong in the grouping and sorting which has been set to force a new page after every record.

With pleasure :)


Any ideas, is it something to do with it all being in detail?

With pleasure :)


Any ideas, is it something to do with it all being in detail?

Yep, that would be it. Put the rest of the stuff in either the report header or the report footer. The only parts that should be in the detail section are the Appointment details (actually that would probably better work as a subreport on there).

I realised as soon as I said it.
Thanks for your help Bob. :D

I realised as soon as I said it.
Thanks for your help Bob. :D

Glad we could assist. :)