Dynamic Query and Report Header

[GregC]

The query is built, the proper report will open and use the info. Each report will give different totals and summaries based on what was chosen to be used.

If, as I build the dynamic query I build a string that explains in everyday language what criteria was chosen, is there a way to place this string in the report header? This way comparing the data and reproducing it as needed will be easier.

 

[PaddyIrishMan]

I would declare a global string variable, use this to build your custom string then write the contents of the variable to a textbox or label in the Report header in the Open event for the Report.

HTH,
Patrick

 

[GregC]

Thanks for the the direction. I am a self taught user, so it is time to dive back into the books. But at least I now know:

1. It can be done
2. The way to do it.

Now all I've got to do is get through #3.

3. Do it.

Thanks

 

[PaddyIrishMan]

No problem at all - what you are trying to do is not difficult at all so don't panic
If you need any assistance just shout.

Regards,
Patrick.

 

[GregC]

What better way to learn than to try and do it myself. However if I encounter some learning difficulties I'll get back to you.

Thanks

 

[GregC]

I couldn't quite get it to work the way you suggested, but I did find another way to make it work thanks to your help.

I created a public function and then assigned it to a textbox in the header.

This may be like reaching around your back to scratch your elbow, but it works.

Thanks