Reports

[24sharon]

I asked my question in 'general' - but maby its more conect here ...

I want to built an option that the customer can built his report by self,
Sure there are the regular reports that I am built, but I want to give the option to build the report by self.

For example if the customer want just the family name and the phone, or all other option than can be in my customer head.
(For this time I don’t want to insert the option of “group” the report)

I thought to create a table with the file’s name, and file’s size, and make like the wizard of access with 2 list boxes that if you click on the first the filed insert to the other, then I have the list of the filed that he want, and the size.
Then I got the place for each filed (0+[sumOfTheFilesSize])

Sure I have to put the option if the letter will be portrait or landscape.

I don’t know where to start
Any idea or small example will be received with happiness

[Sorry on my mistakes in my English, hope that my question be understand]

Good Day!
sharon

 

[daveUK]

Have a look at http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

You should be able to modify this example to suit your needs.

HTH

 

[24sharon]

daveUK

YESSSS!

this example I search

thanks alot
sharon