Search results

  1. O

    Having clause in VBA

    Thank you. Product 1 and 2 are variables. Product 1 = 'TV and Product 2 = 'Camera' How do I do that with a subquery? can you show me an example (SQL w/o VBA)
  2. O

    Having clause in VBA

    Even with 1 HAVING clause i am getting an error My need is to obtain all customers who bought 2-6 TV's AND 8-12 Cameras Can I write it differently?
  3. O

    Having clause in VBA

    I added couple of spaces before/after every string to make sure they won't concat. debug prints this:
  4. O

    Having clause in VBA

    Hello, My first post :) I would like to write the following SQL in VBA : Return all Costumers who bought BETWEEN 2 AND 6 TV's AND also bought BETWEEN 2 AND 6 Cameras 1. Until the HAVING part - all working fine! What am I doing wrong? 2. Is it possible to add multiple conditions to HAVING...
Top Bottom