using a query to construct a report

G

Guest

I've created a Time & Expense access program. I've created a query with
muliple headings. I want to create an expression that will combine the
headings into string. I'm not sure how to do this. I envision the following:

Location. " " Billable hours. " " Merchant. " " Expense Amount. " "
Payment. " " Description.

I expect this to show up in a query field as:

Raleigh, NC. 10 hours. Kinkos. $10.00. Cash. Purchased supplies for
presnetation.

I don't know how to begin layout of this expression within the query.
Thanks in advance for your help.
 
D

Duane Hookom

Do you have a table structure you would like to share with us? How did you
create "a query with multiple headings"? I'm not sure what you mean by
"combine the headings into string".

Can you provide some sample records from your table or existing query, sql
view of your query, field names, and desired output?
 

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

Similar Threads

Using a combobox value and wildcards to filter a query 4
summing hours in a query 9
Convert text string to number in a query 3
Renaming Column Headers with IIf as a Result of a Crosstab Query 3
Using a New Function in a Query 17
Using a Form to supply parameters to a query 13
RE: You tried to execute a query that does not include the specified e 0
Working with dates in a query and . . . 13

Top