Newbie to reports

[hrov]

ive never really used reports before, does anyone have any decent learning material??

I have a form based on a query. At the minute there is 4 lots of info on one page, as in (customer name, address, tel etc)x4. I want one lost of info per page, how do i do this.

And if i have pages of information, how do i refer to the correct textboxes when it comes down to creating formulas. E.g. if i had textbox one on the first page, 2nd page, third page etc. How would i refer to the text box on the 2nd page?

 

[MSAccessRookie]

ive never really used forms before, does anyone have any decent learning material??

I have a form based on a query. At the minute there is 4 lots of info on one page, as in (customer name, address, tel etc)x4. I want one lost of info per page, how do i do this.

And if i have pages of information, how do i refer to the correct textboxes when it comes down to creating formulas. E.g. if i had textbox one on the first page, 2nd page, third page etc. How would i refer to the text box on the 2nd page?

Welcome to the Forum! Since you are new to writing reports, you might want to check out some of the links below to sites that provide online MS Access Turorials. Post back after you have looked at them.

http://office.microsoft.com/en-us/training/CR061829401033.aspx

http://www.fgcu.edu/SUPPORT/OFFICE2000/ACCESS/

http://www.functionx.com/access/

http://databases.about.com/od/tutorials/Tutorials.htm

http://www.softlookup.com/tutorial/access/index.asp

NOTE: The First link is the one that I used when I started out over a year ago. I have checked the others out, and they each offer something that you might find of benefit. GOOD LUCK!

 

[hrov]

Welcome to the Forum! Since you are new to writing reports, you might want to check out some of the links below to sites that provide online MS Access Turorials. Post back after you have looked at them.

http://office.microsoft.com/en-us/training/CR061829401033.aspx

http://www.fgcu.edu/SUPPORT/OFFICE2000/ACCESS/

http://www.functionx.com/access/

http://databases.about.com/od/tutorials/Tutorials.htm

http://www.softlookup.com/tutorial/access/index.asp

NOTE: The First link is the one that I used when I started out over a year ago. I have checked the others out, and they each offer something that you might find of benefit. GOOD LUCK!

just from the first link, i think i have wasted loads of time working out averages in queries!
I havent found the actual answer to my question yet but i am realising what i can possibily do, thanks for the links

(btw im on 2007 access package)

 

[MSAccessRookie]

just from the first link, i think i have wasted loads of time working out averages in queries!
I havent found the actual answer to my question yet but i am realising what i can possibily do, thanks for the links

(btw im on 2007 access package)

I found these links using a Google Search for "Online Access Tutorials". I am sure that if you change that to "Online Access 2007 Tutorials", you will find links that are appropriate for you.