using a query to construct a report

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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?
 
Back
Top