karanj
Last Activity: Jun 7 '07, 05:38 AM
Joined: Jun 6 '07
Location:
-
here effectively the form has to "know" the table/sql - I'd prefer to avoid this if possible so that the queries can be built by one person and the form/report by another. This seems to me something rather straightforward ...... -
Yep, exactly - this kind of basic modularisation would be very helpful! The "official" solution that I've found however is a little disheartening - see this article on the office.microsof t.com site. Surely that means that the query-report-form will effectively be coupled quite tightly?...Leave a comment:
-
Setting a parameter for a report based on a query
Hi all,
I'm facing an issue with Access that I haven't been able to find a solution for, despite hours of googling, so I hope someone here can help!
I've got a report - rptClientsByCou ntry - which is based on a query - qryClientsByCou ntry - that takes a parameter, myCountry, to filter the results. I need to be able to generate this report depending on the user's choice of country, preferably from a drop-down list....
No activity results to display
Leave a comment: