parameters

[Cretin]

I am using access 2000. I need a suggestion. I am using a book and it does not explain things in depth. I have a table with conference, attendees and costs. There may be several attendees for each conference. Is what i want to do now is create a report that if I want can have it total and report on just one conference. The method I am looking at is creating a parameter query and using that to generate the report( the book is lousy at explaining setting up parameter queries). For example I want to report on just the conference wholesaler. How can i set it up so if a report is run they can designate what conference it reports on and just total the expenses for that conference?

Cretin

 

[Cretin]

By playing I asm getting close to figuring out a parameter query butg still would like suggestions if there are better ways to do it.

Cretin

 

[M8KWR]

You could create a form, on the form a combo box or list. Within this lists the different conferences. Once the user selects the conference they want, this value is taken and used within the query (this saves that box appearing for the end users to enter the value they want to query against, it makes it ma bot more user friendly)

Click on a button which creates the report that they want.

If you need any help with setting anything up please let me know, I would be glad to help.

If you let me know you table structure and fields you want to display in the report, and what field you need to query against, I can give you the code for all of it, will not take me 5 minutes or so.

 

[Cretin]

Ok thanks and I may need to take you up on that

Cretin