in need of advise or help!

[garbett_d]

i am 17 years old and have no first hand experiance with access and have been given the task of creating a new data base for the company im working with. i have sucesfully completed most of the database but i am having constant problems with the reports!

they are basic reports but my problem is that in each report the information i am given is on one report! i need each seprate peice of information to be presented in single reports yet still under the original name!

if you have any ideas then please post them to me!
thank you!

 

[ColinEssex]

Hi

Not sure what the problem is - you said....

"they are basic reports but my problem is that in each report the information i am given is on one report! i need each seprate peice of information to be presented in single reports yet still under the original name! "

Are you referring to sub-reports? not sure... Can you expand with example of what you mean?


Col

 

[garbett_d]

i have created a query for example say its named "ian"!
i have filled in all the neccasary information as below!

refrence number raised date raised by deprtment


1 12/01/2001 Ian Lloyd Plant
9 12/01/2001 Ian Lloyd Toner
23 05/05/2001 Ian Lloyd SCM
32 09/05/2002 Ian Lloyd SCM
33 20/05/2002 Ian Lloyd SCM

then create a report for the above information! but all the details appear on one single report! so it looks basically the same as above! i need it so that for example:

refrence number raised date raised by deprtment


1 12/01/2001 Ian Lloyd Plant

is the only thing on the report but there is a new report for each peice of information!
hopefully that is a little easier to understand???

 

[neileg]

Still not crystal clear. Two possibilities

1) You want each record on a separate page
2) You want a report that has just one record, but you want to produce a string of them

Is either of these right? Please let us know why you want to do with these reports. Are you producing a series of forms for distribution, for example.

 

[garbett_d]

the first one sounds about right!
yes its refers to incidents on site!
so for each incedent reported by an sub-ordinate there needs to be a report printed off and filled!

 

[ColinEssex]

So each site can have any number of incidents which are raised by different departments.

If so, why haven't you got the site name or code in your data?


Col

 

[neileg]

So, to create a report that has a single page for each record, put all your info in the detail section.

Open the property box for the detail section of your report and set the Force New Page setting to Before Section.

This will produce a report with each record on each page.

Hope this is what you want.

 

[garbett_d]

niel your a star!
that was perfect, thanx alot!