Merge two fields from field list.

[Yessen]

Please help.
I have a field list and I dragged two items to my report in the design view.

When I preview report it all look just fine.

How can I merge two of these items into one.

Lets say one shows up in the text box field as Field1 and the second one as Field2

How can I make them show up in the same Field as Field1 - Field2.

Notice but "-" I dont mean subtraction, all i meant was hyphen.

 

[KenHigg]

In the query you can do something like:

MyNewField: [MyField1] & " - " & [MyField2]

 

[Yessen]

In the query you can do something like:

MyNewField: [MyField1] & " - " & [MyField2]

thanks that helped and almost worked

In my field list the MyField2 has a name "name"

when I enter that it automatically converts it to "Name", which is the name of the report.

How can I enforce "name" and turn off intuitive auto-filling?

 

[KenHigg]

The golden rule here, coincidentally, is to not use reserved words and give objects unique names. The word ‘name’ is used inside MS Access to do other things. Also preface your object names with things like 'tbl', 'rpt' and 'frm' for tables reports and forms respectively. So use something like tblMyTableName to name a table or rptMyReportName. To name a report.

 

[Yessen]

The golden rule here, coincidentally, is to not use reserved words and give objects unique names. The word ‘name’ is used inside MS Access to do other things. Also preface your object names with things like 'tbl', 'rpt' and 'frm' for tables reports and forms respectively. So use something like tblMyTableName to name a table or rptMyReportName. To name a report.

damn.
I didnt develop the database. I am just asked to add a new report to the existing one

Thanks a lot.
I guess I would have to go and change the name of the column in the table where it stores it

 

[KenHigg]

Sometimes when you 'wrap' your field names in the square brackets you can fix these types of issues. Did you try the square brackets?

 

[Yessen]

Sometimes when you 'wrap' your field names in the square brackets you can fix these types of issues. Did you try the square brackets?

yes I did. it still kept changing it from "name" to "Name".

I have another question.

So I want several rows to show up in the table format like this

Column 1 Column2 Column3
Row1 -------------------
Row2 -------------------
Row3 -------------------
Row4 -------------------
Row5 -------------------

What I did was took three fields and placed them next to each other, and made a thick border around them so it has table format.
Then in the properties set the can grow = "Yes".

But instead of what I expected I get

Column1 Column2 Column3
Row1 -------------------
Column1 Column2 Column3
Row2 -------------------
Column1 Column2 Column3
Row3 -------------------
Column1 Column2 Column3
Row4 -------------------
Column1 Column2 Column3
Row5 -------------------

Maybe I am creating a table the wrong way

 

[KenHigg]

Are you giving up on your first question?

 

[Yessen]

Are you giving up on your first question?

No no no!!
I just changed the name of column in the table and it worked out well

 

[KenHigg]

Oh. Ok...

I think all you need to do is place the column names in the report header section.

 

[Yessen]

Oh. Ok...

I think all you need to do is place the column names in the report header section.

I think the way I am generating table is wrong. Whats the correct way of printing tables in the report?

 

[KenHigg]

I think the way I am generating table is wrong. Whats the correct way of printing tables in the report?

The correct way is to print the way the business needs to see the data. I'm not trying to be short but that is in my mind the starting point. Can you post a sample picture of what it looks like now and then try to describe what they (the business people) want it to look like?

 

[Yessen]

The correct way is to print the way the business needs to see the data. I'm not trying to be short but that is in my mind the starting point. Can you post a sample picture of what it looks like now and then try to describe what they (the business people) want it to look like?

I wish I could do that. This way it will be much easier but in my company I will get fired for that

I think in general the way I am doing it is wrong.

What I am doing it is pulling the field from the Field List table and moving its associated label on top of it and treating it as a column header. But for every row in my query that this report is linked to instead of generating new rows in the table it generates totally new column header and new associated row to it.

 

[KenHigg]

Do you not understand about my suggestion to put the labels in a header section?

 

[Yessen]

Do you not understand about my suggestion to put the labels in a header section?

I did that but for some reason the information in the page header repeats when the table with multiple rows goes beyond one page. It all repeats on the second-third..etc pages

 

[KenHigg]

Then try the report header instead of the page header - ?