Columns in report

[Glennzo]

Hello to all. My first time here and first post.

I'm trying to create a multi column report based on a query. The report will show the weeks of a given month, one week per column, with a label to the left and a totals column on the right. My question is, how do I make the label for each field visible in only the first column? As it is now, the labels are visible in all columns.

Thank you

Glennzo
gjohnz@attbi.com

 

[Glennzo]

Columns in reports

Gee. Ummm. No thoughts?

 

[neileg]

Delete the labels you don't want?

The lack of response is because it's not clear what you want to produce or what you have now.

When you drop a field on a report design grid, Access automatically attaches a label. However, these labels are deleteable. Just select the label and press Delete. Is this all you need?

 

[Glennzo]

Columns in reports

Right. I'm aware of the fact that I can delete just about anything I want to delete. Let me try to clarify.

I created a report, dropped a few fields in it on the left side, went to page setup and randomly chose 4 columns. That's all good, however, the label for each field appears in all 4 columns. What I want is for the label to appear in only the first column, while the data appears in all 4 columns. To be more precise, this report is based on a random month, from data collected over the course of a year. If there's 4 weeks in the month, I'll need a label on the left, 4 more columns each containing one week's worth on data, and finally another column on the right with a monthly total. If there's 5 weeks in the month, then we need to adjust the report accordingly.

Thanks for the reply neileg. To you and all the members, apologies if there appeared to be any bit of rudeness. That was not my intent. I was surprised that, given the number of reads, there were no comments.

Glennzo...

 

[ColinEssex]

Hi

I don't think anybody thought you were being rude.

Its difficult sometimes though because most of those here are usually working and log in from time to time. What happens then is that (depending on time available) can the question be easily answered? is it nice and clear what the prob is? etc etc

Everyone has their own "favourite" bits of Access they feel comfortable in answering - its just a question of matching up all these things.

Bear in mind that there are always alot of "guests" who read the posts but can't reply as they haven't yet become a member. That always bumps up the number of reads.

I'm sure you will get a satisfactory result

BTW - Isn't Salem where they had the witch trials or something? Its supposed to be dead spooky living there isn't it?

Good Luck
Col

 

[Glennzo]

Salem, Mass, USA is indeed where the 'Witch Trials' were held, back in the 1600's.
The 'witches' were tried and usually found guilty of witchcraft, which I don't believe could be proven. They were usually crushed with stone, burned at the stake or hanged at a spot in town called 'Gallows Hill'.

Spooky living here? No more than in any other city/town. There are, interestingly, many residents, usually 'Pagans', that don't subscribe to a 'normal' lifestyle. But that all depends on one's definition of normal. Maybe they're normal and I'm not. They seem to be regarded as 'different' based on what I read, which is of course just the opinion of others. These are the folk who actually believe in and practice witchcraft, and live the lifestyle of modern day witches to some extent. They bother no one and blend in with society to the point where you usually don't even notice. Some of them stand out from the crowd because they tend to dress differently, usually all in black, maybe robes or an ankle length coat or cape complimented by one or more necklaces with some sort of medallion thingy. In other words, far from my blue jeans and t-shirt wardrobe. I've yet to see any ghosts or goblins wandering around town.

If anyone is interested, I will post a link to the web site for the City of Salem, Mass. Their site is very informative regarding the rich history of the city in terms of early shipping/trading and witchcraft as well as the city's political past with regard to early America.

As you Brits say,
Cheers!

Glenn

 

[neileg]

I wasn't offended either!

Perhaps I'm being thick, but I still don't quite get the plot!

I think the problem is the labels attached to the fields. Can you delete these and add some row identifiers of your own?

Have a nice day, now.

 

[Glennzo]

Columns in reports

Create a new report based on any table or query you have handy. Go to file/page setup and the columns tab. Select 4 columns and edit the column width accordingly so all columns appear on one page. Now, drop a field on the extreme left of the report in the detail section. You see:

Label Data

Run the report. You see:

Label Data Label Data Label Data Label Data

If you delete the label, all you see is:

Data Data Data Data

How do we format the report so we see:

Label Data Data Data Data

Hope this helps to clarify my objective.

Even better, I've attached a screenshot. Notice that the text 'Pledged' ,'Loose', 'Initial', etc, appear in all columns. I want that text to appear in the first column only.

Thanks for the help!!!

 

[Glennzo]

Columns in reports

Ok, so I haven't attached a screen shot.

 

[neileg]

Ah, right. I understand now. But I don't know the answer except for a fudge.

The problem is that you are using Access to fill your columns in the detail of your report. Thus anything that you define for your record object in the detail will repeat, including your labels. The columns fill the whole of the detail section so there is no space to the right of the columns in the detail section to add unbound labels, so if you delete the record labels, you loose them all.

The fudge is a to add a background image to your report that has the text embedded in it that you want to use as your labels. You will have to juggle your column widths and the size of your background.

The other way is to design a report that has enough text boxes to hold the maximum number of records you might need to show. Then populate these individually.

Hope this helps

 

[Glennzo]

It looks as though I'll have to look at reports with sub-reports to solve my dilemma. One thought might be to export the data to Word and just add the labels by hand. We've already tried that. It will suffice, but it definitely makes everything a lot less dynamic.

 

[neileg]

Few points:

1) As far as I know, Access doesn't seem to support columns in a sub report.
2) If you use Excel instead of Word, you may be able to set up a tabular template that will give you what you want
3) Are you sure a tabular format report won't give you most of what you want

As the Rolling Stones would say: You can't always get what you want, but if you try sometimes well you just might find you get what you need

 

[Glennzo]

Wow! Why didn't I think of that? You may just be right Neil. A tabular report might be just what the doctor ordered. If it wasn't for the fact that I'm playing around with Linux at the moment I'd be trying your idea out. Stay tuned...

 

[Glennzo]

Columns in reports

Ok, found the answer to my question. I stumbled across Microsoft Knowledge Base Article 153052 and it held the solution. If you're interested, have a look at it. It would probably be better than any long winded description I could offer here.

Thanks a bunch for all the help you folks have offered!!!1

Glennzo....