Report Format / Presentation

[SteveF]

Hi folks, I wonder if some of you good people could point me in the right direction?

I have attached a sample of part of a report I am trying to re-produce in Access and am struggling with.

I have a query producing all the equations I need, so the numbers themselves are pretty straightforward, but the formatting is a problem and getting the numbers to total down has me baffled.

Any and all pointers appreciated.

 

[Destiny]

Do you need to have it exactly like in that pdf?
What version of Access do you have?

 

[pl456]

You should explain what you mean by formatting, what are you struggling with?

With regards to totals you put unbound controls on the report with control source property set to e.g.
=Sum([Stock on hand])

 

[SteveF]

Sorry, formatting as in presentation; the way it is presented is important.

 

[pl456]

I got that, what are you struggling with? which part of the report?

 

[SteveF]

Do you need to have it exactly like in that pdf?
What version of Access do you have?

That's only part of it, but it does need to be presented like that yes. There are other fields with equations in but they seem more straightforward.

 

[SteveF]

I got that, what are you struggling with? which part of the report?

I don't know how to get those rows to present in a report like that, and I don't know how to get columns to total downwards. You've answered the second part already though I think.

 

[SteveF]

Edit:

I would be happy to give up the box / border part of the presentation if I need to. That's not so important as getting the actual rows and columns in the right place.

Forgot to say I'm using Access 2003.

Thanks for help.

 

[pl456]

perhaps you should post your db and I will have a look

 

[SteveF]

Ok, I have attached what I have done so far. I'm happy-ish with the inputting side with the simple forms I have, and the tables/query side seems to be doing the calculations I need but the whole thing is a learning curve.

I think that all the information I need is there, it's really a case of getting it to report in the way I want.

 

[pl456]

Had a look, hope this is kind of what you want. I created a crosstab query to sum the data, you will see what I mean.

 

[SteveF]

That's brilliant, sets me on the right path. Thanks.