expression builder / dynamic report

[AJ]

Two questions:
1. Does anyone ahev any good websites to help me with the expression
builder. I have written a VBA procedure, understand programming but have not
found anythng to help me understand how (correctly) to use this tool to help
me on my reports. (I think it can be very useful if I could just figure it
out.
2. Is there a way to dynamically create a report based on a parameter or
query?

 

[Tom Wickerath]

Hi AJ,

I'll take a stab at your second question. You can dynamically create the
WHERE clause of a SQL statement (or even the entire SQL statement) that
serves as the recordsource for a report. Thus, one report can be used to
allow the user to pick and choose what they want to see from an input form.
Access MVP Armen Stein has a good example on his web site that you can
download. See "Report Selection Techniques", here:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________