By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Create a report from user entry.

P: 6
User will make choices from multiple drop-down lists of variables with the capability of making more than one choice from each list. Can this be done without using vb or sql. If not, what would be the best way to do it using SQL and not vb
Dec 6 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
A report needs a "fixed" recordset. Only by code you can manipulate this.
A fixed recordset indicates a fixed query (SQL) statement.
The only "codefree" solution is to instruct the user to create a select query from your table (or another basic report query you made for him) and let him fire with that the report wizard.

Dec 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.