Hello Access Experts ,

I would like to make a query, based on the input of the user. I already have created a form, on which the user can select the possible fields to be displayed (including a optional filter).

The corresponding sql - code is generated with VBA (a SQL string starting with SELECT - FROM command expanded with the selected fields with the use of if-then-else. The filter is created with the use of the WHERE () command

Only I can't seem to make it work. Can anyone help me?

A second question is that I would like to display the selected data into a graph, but have no idea how to do this.

Thx in advance.

Marc

This was posted in the Access Forum. Check there for more information.

-Shay Shepston

If you want to get some help you need to show us what you did do and how it went wrong. Right now must of us looking on have no idea what you are really asking.

-Phil-

Why are we posting to questions asked more than 3 years ago? Who is digging all of these up?



mmcdonal