Hello Rick, everyone,

I have this SQL statement I "borrowed" from a query to fill a listbox on a form using some criteria from that form.

Now I need to build in the criteria for my TOP Values like in the SQL2 seminar. Due to the "normalisation" of my tables there are a lot of "JOINS" in the statement.

Now it won't fit on one line and therefor I failed to get it working, even with the normaly used "_" or " " & _" shown in the Access classes.

Reason might be the place I try to "cut"  the lines. As said the "Joins" might been the problem or the statement needs to have some commands in one line that don't fit anymore due to.

Can anyone help me out?

For now I set it by using a fixed number but it would be "cleaner" to give the end-user more flexibility.

Thanks again
eddy peanut

---

Reply from Richard Rost:

Let's see it.