Access From -> Report Help

[Lunchbox12682]

I am new to using Access and cannot figure out how to do what I am planning.

I was given a database and asked to make a form that will print out various reports based on selected items in the form. Making the form wasn't to bad, and I think I have the code for the commands to goto the reports set corretly. However, I am unsure how to build my report. I am currently using the form to build a query to get the data I need, but I don't know how to get it in the report. I tried the wizards at first, but they don't help with dynamic queries.

As I am new to Access and VBA, I may be missing some feature. Any help would be appreciated.

 

[statsman]

Reports are tough when you're new to Access.

The first question is, does you client/boss want the report to look just like the form?
If so, you can print the actual form by using the command button wizard while you're in the forms design view.
If not, you can create a report. Use the same query that is running your form and use it to create a report.

 

[Lunchbox12682]

Well I figured out some of my problems. I can get a query to work dynamically with the variables for items in the form, but if I need to adjust the items (i.e. get a single variable out of a combination of check boxes by applying some formula) I'm not sure how to pass that from form to report.


The report doesn't have to look like the form. The form is basically the options for the report.

Also, when I have multiple check boxes in a single option group only one can be checked at a time and I can't uncheck them all. Is there an option I'm missing, or do they just haveto all be in seperate option groups?

 

[daveUK]

The following example should give you an idea

http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

HTH