Is it possible to Merge columns in a Report

[nik9]

Hello All,


I am a newbie in Access creating reports and queries. I am seeking help with an existing excel report, I have created a database for in Access. Now, I am at the createing a report stage and would like to build my report in the same presentation as my existing excel report. Currently, my excel reports presents the expense spend by vice president and their respective departments in three merge column titles: YTD (year to date), MTD (month to date), and FY(full year). Is it possible to merge columns in Access?

In each respective merge column for example: on line 5, I have 6 columns D-I within the YTD merged column (line 4), J column is blank, K-N is 4 columns MTD merged (line 4), and 6 columns T-Y columns for FY merged columns (line 4).

I'm not quite sure how to copy an example here, but I am hoping I have given enough detail to get help. Please let me know if I need to elaborate further.
Thanks

[Robeen]

You CAN 'merge' columns in an Access query.
In your Query Design -> construct a field like this:
MergedFieldNameYouWant: FieldName1 + " " + FieldName2 + " " FieldName3 . . .

I might do something like that if I was concatenating a LastName, MiddleInitial & FirstName . . . or different Address Lines into one field in the report.
If you're just concatenating text values then I don't suppose there'd be a problem . . . you didn't specify what kind of data was in each of your merged columns.

Let me know if I answered your question.

[ssanfu]

MergedFieldNameYouWant: FieldName1 + " " + FieldName2 + " " FieldName3

Robeen, It looks like you missed an operator at the last fieldname...

MergedFieldNameYouWant: FieldName1 + " " + FieldName2 + " " + FieldName3

And, while that will probably word, for concatenating, the preferred (from my readings) operator is the ampersand:

MergedFieldNameYouWant: FieldName1 & " " & FieldName2 & " " & FieldName3

[Robeen]

lol . . . my bad on both counts.

. . .about the '+' instead of the '&' . . .
I'm working in an enviroment where '+' is the concatenating operator!
Thanks Steve!!

[nik9]

no problem, I'll re-try