I am very much looking forward to this seminar. Here is an example i would like demonstrated. When i copy an SQL statement from a query that has calculated fields (e.g., IIF(...)) and then use it to populate a list box or report using VBA, it doesn't work. How can you manipulate the SQL statement with calculated fields to populate a listbox? How i have got around it is usually is to create another query but i guess there could be an alternative Best regards, MICAH
Reply from Richard Rost:
You can NEST queries in SQL (like making queries based on other queries). Can you give me a specific example of one that doesn't work for you?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Working on SQL Part 2.
